Hello
2008/4/28 <seijin@gmail.com>:
> Hi,
>
> I'm fairly new to PG and databases in general so this may very well be
> a problem in my thought process.
>
> If I have a simple table with an ID (integer) and Animal (text) like
> this...
>
> 1 Dog
> 2 Cat
> 3 NULL
> 4 Horse
> 5 Pig
> 6 Cat
> 7 Cat
>
> ... and I do something like "select id where animal <> 'Cat';" then
> shouldn't 1, 3, 4 and 5 be picked? As it is I only get 1, 4 and 5.
> NULL is not 'Cat'. I realize that if I were testing for NULL itself I
> would use IS or IS NOT but this...? I'm a little confused.
>
In this case use operator IS DISTINCT FROM
select id where animal IS DISTINCT FROM 'Cat';
Regards
Pavel Stehule
> Thanks!
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>