On Tue, 2 May 2006, James wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2417
> Logged by: James
> Email address: james@mercstudio.com
> PostgreSQL version: 8.1
> Operating system: Microsoft Windows XP Professional
> Description: bug for finding string in column
> Details:
>
> hi,
>
> 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.
If it's null, it's actually returning unknown (not true or false) and
as far as we know that's not a bug because that's how SQL defines the
comparison operators.