Message-ID: <001901c27432$efda8ea0$4528a8c0@cblan.mblox.com>
From: "Peter Galbavy" <peter.galbavy@knowtion.net>
To: "Peter Galbavy" <peter.galbavy@knowtion.net>,
	<pgsql-sql@postgresql.org>
References: <000901c27431$e02a8e20$4528a8c0@cblan.mblox.com>
Subject: Re: IGNORE ME how do i insert an empty string ?
Date: Tue, 15 Oct 2002 11:09:23 +0100
Organization: Knowtion Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Please ignore me for now. The string is NOT empty, but full of NUL
characters. My bad for not using 'less' to view the output...

Peter

----- Original Message -----
From: "Peter Galbavy" <peter.galbavy@knowtion.net>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, October 15, 2002 11:01 AM
Subject: [SQL] how do i insert an empty string ?


> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>