RE: [SQL] IIF..

-----Original Message-----
From: Clark Evans [mailto:clark.evans@manhattanproject.com]
Sent: Monday, March 29, 1999 6:01 PM
To: Jackson, DeJuan
Cc: Eduardo Noeda; pgsql-sql@postgreSQL.org
Subject: Re: [SQL] IIF..

"Jackson, DeJuan" wrote:

It would be:
SELECT (CASE Number
WHEN 1 THEN 'First'
ELSE 'Other'
END) AS Description
FROM Table

Way cool. A new trick for me.
This is similar to DECODE, I assume.

However, I tried this test on a snapshot
about a week old, and this is the result:

Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: clark

clark=> create table test (a text, b int4 );
CREATE
clark=> insert into test values ( 'one', 1);
INSERT 18634 1
clark=> insert into test values ( 'two', 2);
INSERT 18635 1
clark=> insert into test values ( null, null);
INSERT 18636
clark=> select ( case b when 1 then 'first' else 'other'

end ) as xx from test;

ERROR: copyObject: don't know how to copy 704
clark=>

Did this work in earlier versions? If so, then perhaps this
should be added to a regression test if it isn't already.

Best,

Clark