Re: PHP and PostgreSQL

Ok I just tested this: "insert into tableBlah (name, review) values ('me',NULL)" That does insert a NULL for review. Then I do this: "select * from tableBlah where review is NULL" I get: name | review ------+--------- me | So inserting the NULL does work. You just need to programmatically build your insert statement such that you put "NULL" where review goes, or "'the review string'" if there's a real value. michael --- Corey Mosher <corey@hub.org> wrote: > Michael, > > This does not work for me, I have tried it already. > > Corey > > On Tue, 4 Jul 2000, Michael Teter wrote: > > > "insert into someTable (someColumn) values (NULL)" > > > > or > > > > $someVar = "NULL" > > "insert into someTable(someColumn) values > ($someVar)" > > > > or if you're not sure if someVar will have a real > > value or instead a null value, do this: > > > > ...test $someVar... is it null or all space? > > yes: $someVar = "NULL" > > no: $someVar = "'" . $someVar . "'" > > > > then do this again: > > "insert into someTable(someColumn) values > ($someVar)" > > > > michael > > > > --- Corey Mosher <corey@hub.org> wrote: > > > Hi, > > > I am trying to do an insert into my > postgreSQL > > > database > > > from a form. When I try to insert a null value, > it > > > gets > > > put into the database as a string of spaces. > Any > > > ideas as to > > > why and how to insert the correct null value? > > > > > > Corey Mosher > > > Hub.Org Networking Services > > > Wolfville, NS > > > Canada > > > corey@hub.org > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: > > > php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: > > > php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > > > php-list-admin@lists.php.net > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Kick off your party with Yahoo! Invites. > > http://invites.yahoo.com/ > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: > php-general-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > Corey Mosher > Hub.Org Networking Services > Wolfville, NS > Canada > corey@hub.org > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > For additional commands, e-mail: > php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/