Bug #840: Query with null string

Stphane Brub (sirber(at)webernic(dot)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.php on line 27

Warning: pg_fetch_object(): supplied argument is not a valid PostgreSQL result resource in /var/www/include/fr/sub/info/news/newdisplay.php on 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

Stphane Brub

Sample Code
SELECT * FROM tbluser WHERE userid = ""

No file was uploaded with this report