Re: Celko: help with an experiment
From: Guillermo Labatte <labatteg_at_yahoo.com>
Date: Thu, 04 Jul 2002 08:39:06 -0300
Message-ID: <3D2433DA.8000702_at_yahoo.com>
[ ] Other
[ ] Other
Received on Thu Jul 04 2002 - 13:39:06 CEST
Date: Thu, 04 Jul 2002 08:39:06 -0300
Message-ID: <3D2433DA.8000702_at_yahoo.com>
PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96
CREATE TABLE Foobar (I INTEGER NOT NULL);
INSERT INTO Foobar VALUES (1);
- SELECT * FROM Foobar;
[ ] 0
[X] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other
2) SELECT MAX(i) FROM Foobar;
[ ] 0
[X] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other
3) SELECT * FROM Foobar WHERE 1 = 0;
[ ] 0
[ ] 1
[ ] 99
[ ] NULL
[X] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other
4) SELECT MAX(i) FROM Foobar WHERE 1 = 0;
[ ] 0
[ ] 1
[ ] 99
[X] NULL
[ ] Empty set
[ ] Warning
[ ] Fatal error
[ ] Other
5) SELECT CASE WHEN 1 = 1
THEN 99 ELSE COUNT(*) END AS x FROM Foobar WHERE 1 = 0;[ ] Fatal error
[ ] 0
[ ] 1
[X] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Other
6) SELECT CASE WHEN 1 = 0
THEN 99 ELSE COUNT(*) END AS x FROM Foobar WHERE 1 = 0;[ ] Fatal error
[X] 0
[ ] 1
[ ] 99
[ ] NULL
[ ] Empty set
[ ] Warning
[ ] Other
Received on Thu Jul 04 2002 - 13:39:06 CEST