Re: where clause bug

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