On Fri, 6 Dec 2002 pgsql-bugs(at)postgresql(dot)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.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-12-06 22:40:17|
|Subject: Re: GEQO Triggers Server Crash |
|Previous:||From: pgsql-bugs||Date: 2002-12-06 21:49:15|
|Subject: Bug #840: Query with null string|