Re: Bug #840: Query with null string

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <sirber(at)webernic(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #840: Query with null string
Date: 2002-12-06 21:58:08
Message-ID: 20021206135616.B21321-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-12-06 22:40:17 Re: GEQO Triggers Server Crash
Previous Message pgsql-bugs 2002-12-06 21:49:15 Bug #840: Query with null string