Re: where clause bug

On 11 Jun 2001 16:52:09 +0200, Peter Eisentraut wrote:
> kyle 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

cu
--
 Nabil Sayegh