From: | "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net> |
---|---|
To: | "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: how do i insert an empty string ? |
Date: | 2002-10-15 10:03:50 |
Message-ID: | 001001c27432$293bd8d0$4528a8c0@cblan.mblox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Sorry: 7.3 beta 2 on OpenBSD 3.2
Peter
----- Original Message -----
From: "Peter Galbavy" <peter(dot)galbavy(at)knowtion(dot)net>
To: <pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Galbavy | 2002-10-15 10:09:23 | Re: IGNORE ME how do i insert an empty string ? |
Previous Message | Peter Galbavy | 2002-10-15 10:01:47 | how do i insert an empty string ? |