Thread

1. RE: [SQL] IIF..

   Jackson, DeJuan <djackson@cpsgroup.com> — 1999-03-30T00:31:19Z

   Try it on current snapshot. Any comment Jan?
   	-DEJ
   > -----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
   > 
   
   

2. SELECT (CASE ... ) gives copyObject error in current CVS build.

   Clark C . Evans <clark.evans@manhattanproject.com> — 1999-03-30T02:43:00Z

   I'm receiving the following error testing SELECT (CASE with
   the recent cvs replication ( 29MAR99 , 8:30PM EST).
   
   
   > 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=> 
   >