Re: Inserting NULL into Integer column

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>
Cc: Jeremy Smith <jer(at)highboard(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Inserting NULL into Integer column
Date: 2004-02-18 20:53:55
Message-ID: 1077137634.18564.418.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

> 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message scott.marlowe 2004-02-18 20:58:31 Re: Inserting NULL into Integer column
Previous Message scott.marlowe 2004-02-18 20:44:47 Re: Inserting NULL into Integer column

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2004-02-18 20:58:31 Re: Inserting NULL into Integer column
Previous Message scott.marlowe 2004-02-18 20:44:47 Re: Inserting NULL into Integer column