Re: Inserting NULL into Integer column - Mailing list pgsql-sql

From scott.marlowe
Subject Re: Inserting NULL into Integer column
Date
Msg-id Pine.LNX.4.33.0402181357470.3399-100000@css120.ihs.com
Whole thread Raw
In response to Re: Inserting NULL into Integer column  (Rod Taylor <pg@rbt.ca>)
Responses Re: Inserting NULL into Integer column
List pgsql-sql
On Wed, 18 Feb 2004, Rod Taylor wrote:

> > and then you can foreach across the input:
> > 
> > foreach($fields as $f){
> >   if (!$_POST[$f]){
> >     $_POST[$f]='DEFAULT';
> >   } else {
> >     $_POST[$f] = "'".$_POST[$f]."'";
> >   }
> > }
> 
> Default in quotes isn't going to work, and please tell me you escape
> those things with pg_escape_string() at some point.

Note that the ' marks aren't part of the string, they are the delimiter of 
the string, and I always run every server with magic_quotes_gpc on.

anything else? :-)



pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Inserting NULL into Integer column
Next
From: Rod Taylor
Date:
Subject: Re: Inserting NULL into Integer column