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

Stéphane Bérubé (sirber@webernic.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Query with null string

Long Description
When I do a query (SELECT or INSERT) with null vars (see example) I get warnings from php:

Warning: pg_query() query failed: ERROR: pg_atoi: zero-length string in
/var/www/include/fr/sub/info/news/newdisplay.phpon line 27 

Warning: pg_fetch_object(): supplied argument is not a valid PostgreSQL result resource in
/var/www/include/fr/sub/info/news/newdisplay.phpon line 28 

because the WHERE was empty. This code worked fine on PostGreSQL 7.2.x. Now I'm on 7.3rel-4.

Any idea?

Thanks

Stéphane Bérubé

Sample Code
SELECT * FROM tbluser WHERE userid = ""


No file was uploaded with this report