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

From: Clark Evans <clark(dot)evans(at)manhattanproject(dot)com>
To: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>, jwieck(at)debis(dot)com, hackers(at)postgreSQL(dot)org
Subject: SELECT (CASE ... ) gives copyObject error in current CVS build.
Date: 1999-03-30 02:43:00
Message-ID: 37003A34.B0AD8F49@manhattanproject.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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=>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 1999-03-30 03:57:41 Re: [HACKERS] vacuum updated...
Previous Message The Hermit Hacker 1999-03-30 01:49:56 Re: [HACKERS] vacuum updated...

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Merrill 1999-03-30 03:27:33 indexing a datetime by date
Previous Message Jackson, DeJuan 1999-03-30 00:31:19 RE: [SQL] IIF..