Received: from smtp4.mindspring.com (smtp4.mindspring.com [207.69.200.64]) by hub.org (8.9.2/8.9.1) with ESMTP id VAA71845 for ; Mon, 29 Mar 1999 21:46:56 -0500 (EST) (envelope-from clark.evans@manhattanproject.com) Received: from manhattanproject.com (pool-207-205-160-67.nwrk.grid.net [207.205.160.67]) by smtp4.mindspring.com (8.8.5/8.8.5) with ESMTP id VAA11762; Mon, 29 Mar 1999 21:46:51 -0500 (EST) Sender: clark@mindspring.com Message-ID: <37003A34.B0AD8F49@manhattanproject.com> Date: Tue, 30 Mar 1999 02:43:00 +0000 From: Clark Evans X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: "Jackson, DeJuan" , jwieck@debis.com, hackers@postgreSQL.org Subject: SELECT (CASE ... ) gives copyObject error in current CVS build. References: <37002534.1AACAFFC@manhattanproject.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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=> >