Re: Bug #840: Query with null string - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Bug #840: Query with null string
Date
Msg-id 20021206135616.B21321-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Bug #840: Query with null string  (pgsql-bugs@postgresql.org)
List pgsql-bugs
On Fri, 6 Dec 2002 pgsql-bugs@postgresql.org wrote:

> Sample Code
> SELECT * FROM tbluser WHERE userid = ""

I assume you mean '' rather than "".

0 length strings used to be interpreted as having
the value 0 when converted into an integer.  Now it
throws an error instead.  There was some discussion
at the time it happened and some more recently on
the mailing lists, you should be able to get more
info from the archives.

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #840: Query with null string
Next
From: Tom Lane
Date:
Subject: Re: GEQO Triggers Server Crash