Re: NULL vs. Empty String

From: "Daniel Kirkwood" <dmk(at)worfie(dot)net>
To: "David Wheeler" <david(at)wheeler(dot)net>, <pgsql-general(at)postgresql(dot)org>
Cc: <dbi-users(at)perl(dot)org>
Subject: Re: NULL vs. Empty String
Date: 2001-03-14 06:50:17
Message-ID: 003901c0ac53$08d95de0$170c0b0a@cairo.iteru.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Of course, depending on the application, this could mean hand-modifying
every script... so my apologies if this was not what you were after ;)

> Could it be as simple as:

> $sth = $dbh->prepare("INSERT INTO table (row1, row2) VALUES (?, ?)");
> if ( $webinput eq "" ) { $webinput = undef ; }

> $sth->execute($webinput, $otherstuff);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-03-14 06:56:32 Re: Fw: Fw: Please Help
Previous Message Daniel Kirkwood 2001-03-14 06:48:02 Re: NULL vs. Empty String