Re: [BUGS] BUG #2417: bug for finding string in column

2006-05-02 Thread Bruno Wolff III
On Tue, May 02, 2006 at 10:34:12 +, James <[EMAIL PROTECTED]> wrote: > > i've encounter bug where when a field is empty / null (type varchar(255) ), > when i use the sql query <> 'myvalue', it seems to be false all the time. Empty and NULL are not the same thing. NULL <> to any value evalua

Re: [BUGS] BUG #2417: bug for finding string in column

2006-05-02 Thread Stephan Szabo
On Tue, 2 May 2006, James wrote: > > The following bug has been logged online: > > Bug reference: 2417 > Logged by: James > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Microsoft Windows XP Professional > Description:bug for finding st

[BUGS] BUG #2417: bug for finding string in column

2006-05-02 Thread James
The following bug has been logged online: Bug reference: 2417 Logged by: James Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Microsoft Windows XP Professional Description:bug for finding string in column Details: hi, i've encounter bug