where clause bug - Mailing list pgsql-bugs

From kyle
Subject where clause bug
Date
Msg-id 20010608215450.91619.qmail@web13507.mail.yahoo.com
Whole thread Raw
Responses Re: where clause bug  (Peter Eisentraut <peter_e@gmx.net>)
Re: where clause bug  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
When specifying criteria in a where claue such as
user_id = 'value' if a non-numeric is entered the
query returns back all rows.
user_id = user_id brings back every user_id instead of
error because user_id is a numeric field and it
shouldnt be able to accept chars.
-Kyle

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/

pgsql-bugs by date:

Previous
From: Kevin Cole
Date:
Subject: Bug in PostgreSQL/Python (7.1.1/1.5) fetchone()
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432