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
On Fri, Oct 27, 2000 at 02:17:23PM +0200, Peter Pilsl wrote:
select * from test where entry=Null;
select * from test where entry is not NULL;
or
select * from test where entry is NULL;
--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744
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
Show quoted text
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
Import Notes
Resolved by subject fallback
