Re: Celko: help with an experiment

From: Aloha Kakuikanu <alohakaku_at_yahoo.com>
Date: 6 Jul 2002 12:48:36 -0700
Message-ID: <5370feb0.0207061148.6ea34668@posting.google.com>

Sibyl v5.7:

SQL>CREATE TABLE Foobar (I INTEGER NOT NULL);

Grudgingly created.  

SQL> INSERT INTO Foobar VALUES (1);

Added the thingy.

SQL> SELECT * FROM Foobar;

I

---

$.99

SQL> SELECT MAX(i) FROM Foobar;

MAX(I)

---

3 easy payments of $19.99

SQL> SELECT * FROM Foobar WHERE 1 = 0;

Sibyl-01289: Take some math in local community college to learn that 1 is not equal to 0  

SQL> SELECT MAX(i) FROM Foobar WHERE 1 = 0;

Sibyl-01297: Why do you still believe that 1 = 0 ?

SQL> SELECT CASE WHEN 1 = 1

               THEN 99
                ELSE COUNT(*) END AS x
      FROM Foobar
     WHERE 1 = 0;

Sibyl-01293: Tired of this "1 = 0". Ninety Nine, if you insist.

SQL> SELECT CASE WHEN 1 = 0

                THEN 99
                ELSE COUNT(*) END AS x
      FROM Foobar
     WHERE 1 = 0;

Sibyl-01291: Stop trolling with this "1 = 0"! Giving up: go count yorself. Received on Sat Jul 06 2002 - 14:48:36 CDT