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

Re: where clause bug

From: Nabil Sayegh <nsmail(at)sayegh(dot)de>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: kyle <reddwarf91(at)yahoo(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: where clause bug
Date: 2001-06-11 16:41:06
Message-ID: 992277669.18591.0.camel@billy.labor.localnet (view raw or flat)
Thread:
Lists: pgsql-bugs
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



In response to

Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-06-11 18:03:11
Subject: Re: where clause bug
Previous:From: meeta bhateDate: 2001-06-11 16:07:46
Subject: Re: Information regarding foriegn key constraint.

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