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