how do i insert an empty string ?

From: "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: how do i insert an empty string ?
Date: 2002-10-15 10:01:47
Message-ID: 000901c27431$e02a8e20$4528a8c0@cblan.mblox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

FAQ: A search yielded nothing explicit...

I have an INSERT statement:

INSERT INTO metadata (md5, origin, name, value)
VALUES ('fd859f263bd0579935f2146a22d24f32', 'EXIF',
'UserComment', '')

but this fails (using Perl DBI, DBD::Pg) because $dbh->quote() returns two
single quotes, which fails because something along the way thinks this is a
single quote. I do NOT want to insert a NULL but an empty string...

(This is either doing a $dbh->do(...) or a prepare ... execute without
$dbh->quote())

Peter

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Galbavy 2002-10-15 10:03:50 Re: how do i insert an empty string ?
Previous Message Richard Huxton 2002-10-15 08:23:15 Re: Slow performance on MAX(primary_key)