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

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.