From: | "Len Morgan" <len-morgan(at)crcom(dot)net> |
---|---|
To: | "Peter Pilsl" <pilsl(at)goldfisch(dot)at>, "postgres mailinglist" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: select and null |
Date: | 2000-10-27 13:11:14 |
Message-ID: | 002401c04017$633643a0$0908a8c0@H233.bstx.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
select * from test where entry NOT NULL ;
:-)
-----Original Message-----
From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
To: postgres mailinglist <pgsql-general(at)postgresql(dot)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(at)goldfisch(dot)at
>pgp-key available
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2000-10-27 13:16:20 | Re: select and null |
Previous Message | Adam Lang | 2000-10-27 12:53:31 | Re: Postgres 7.0.2-2 on Red Hat 7.0? |