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

Re: where clause bug

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Nabil Sayegh <nsmail(at)sayegh(dot)de>
Cc: kyle <reddwarf91(at)yahoo(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: where clause bug
Date: 2001-06-11 18:03:11
Message-ID: Pine.LNX.4.30.0106112001410.756-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
Nabil Sayegh writes:

> > > When specifying criteria in a where claue such as
> > > user_id = 'value' if a non-numeric is entered the
> > > query returns back all rows.
>
> nml=# CREATE temp table tempo (a int);
> nml=# INSERT INTO tempo values (1);
> nml=# INSERT INTO tempo values (2);
> nml=# INSERT INTO tempo values (3);
> nml=# INSERT INTO tempo values (4);
> nml=# SELECT * from tempo where a='a';
> ERROR:  pg_atoi: error in "a": can't parse "a"
>
> > > user_id = user_id brings back every user_id instead of
>
> FIELD_N = FIELD_N is always true

I don't see an issue here.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

pgsql-bugs by date

Next:From: Cary O'BrienDate: 2001-06-12 14:28:11
Subject: Index files grow forever?
Previous:From: Nabil SayeghDate: 2001-06-11 16:41:06
Subject: Re: where clause bug

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