Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group