select and null

From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
To: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
Subject: select and null
Date: 2000-10-27 12:17:23
Message-ID: 20001027141722.B5336@i3.atat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert D. Nelson 2000-10-27 12:20:00 RE: Postgres 7.0.2-2 on Red Hat 7.0?
Previous Message Peter Pilsl 2000-10-27 12:13:07 Re: Time Difference