select * from test where entry NOT NULL ;
:-)
-----Original Message-----
From: Peter Pilsl <pilsl@goldfisch.at>
To: postgres mailinglist <pgsql-general@postgresql.org>
Date: Friday, October 27, 2000 7:41 AM
Subject: [GENERAL] select and null
>I have a table and want to print out all entries that are not Null ...
>
>select * from test;
> entry
>-------
> 1
> 2
> 3
>
>(4 rows)
>
>select * from test where entry=Null;
> entry
>-------
>
>(1 row)
>
>select * from test where entry<>Null;
> entry
>-------
>(0 rows)
>
>
>select * from test except select * from test where entry=Null;
> entry
>-------
>(0 rows)
>
>
>What is my brain missing here ???
>
>thanks,
>peter
>
>
>--
>mag. peter pilsl
>email: pilsl@goldfisch.at
>pgp-key available
>