Postgres Pro
Downloads
Home   >   mailing lists

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

From Rod Taylor
Subject Re: Inserting NULL into Integer column
Date
Msg-id 1077137634.18564.418.camel@jester
Whole thread Raw
In response to Re: Inserting NULL into Integer column  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Inserting NULL into Integer column  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
Tree view 
> 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.

pgsql-sql by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Inserting NULL into Integer column
Next
From: "scott.marlowe"
Date:
Subject: Re: Inserting NULL into Integer column