Re: BUG #2417: bug for finding string in column - Mailing list pgsql-bugs

On Tue, May 02, 2006 at 10:34:12 +0000,
  James <james@mercstudio.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).