Received: from esri2.esri.com (dwp.esri.com [198.102.62.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9VLohl08960; Tue, 31 Oct 2000 16:50:43 -0500 (EST) (envelope-from gdaswani@esri.com) Received: from narn (narn.esri.com [46.1.37.238]) by esri2.esri.com (8.8.8+Sun/8.8.8) with SMTP id NAA02363; Tue, 31 Oct 2000 13:49:52 -0800 (PST) Message-ID: <006e01c04384$e4bb2d30$ee25012e@narn> From: "George Henry C. Daswani" To: Cc: Subject: Problem with coalesce.. Date: Tue, 31 Oct 2000 13:52:41 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006B_01C04341.D6768280" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200010/84 X-Sequence-Number: 85 This is a multi-part message in MIME format. ------=_NextPart_000_006B_01C04341.D6768280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Was wondering if such a call is unsupported, or a bug? 7.0.2 (postgresql, linux redhat 7.0) SELECT COALESCE ((SELECT NULL,1)=20 returns a 1, correct.. however.. SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME =3D 'BUYER= '),1) returns a "UNKNOWN expression type 501" SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME =3D 'BUYER'; returns a '0' Thanks.. George ------=_NextPart_000_006B_01C04341.D6768280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
    Was wondering if such a= call is=20 unsupported, or a bug?
 
7.0.2 (postgresql, linux redhat 7.0)
 
SELECT COALESCE ((SELECT NULL,1)
 
returns a 1, correct..
 
however..
 
SELECT COALESCE ((SELECT CURVALUE FROM TAB= LEKEYS=20 WHERE TABLENAME =3D 'BUYER'),1)
 
returns a "UNKNOWN expression type=20 501"
 
SELECT CURVALUE FROM TABLEKEYS WHERE TABLE= NAME =3D=20 'BUYER'; returns a '0'
 
Thanks..
 
George
 
 
------=_NextPart_000_006B_01C04341.D6768280--