Re: BUG #2417: bug for finding string in column

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: James <james(at)mercstudio(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2417: bug for finding string in column
Date: 2006-05-03 00:05:00
Message-ID: 20060503000500.GA31652@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, May 02, 2006 at 10:34:12 +0000,
James <james(at)mercstudio(dot)com> 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 evaluates
to NULL which will not satisfy a WHERE clause. This is according to the
SQL (i.e. it's not a bug).

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-03 00:11:00 Re: BUG #2418: number & date & time
Previous Message Stephan Szabo 2006-05-02 22:17:05 Re: BUG #2417: bug for finding string in column