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

where clause bug

From: kyle <reddwarf91(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: where clause bug
Date: 2001-06-08 21:54:50
Message-ID: 20010608215450.91619.qmail@web13507.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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/

Responses

pgsql-bugs by date

Next:From: Rony KhouryDate: 2001-06-09 21:24:17
Subject: Re: furiously yours
Previous:From: Tom LaneDate: 2001-06-08 21:51:38
Subject: Re: Apparent deadlock for simultaneous sequential scans

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