Problem with coalesce..

From: "George Henry C(dot) Daswani" <gdaswani(at)esri(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Problem with coalesce..
Date: 2000-10-31 21:52:41
Message-ID: 006e01c04384$e4bb2d30$ee25012e@narn
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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)

returns a 1, correct..

however..

SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'),1)

returns a "UNKNOWN expression type 501"

SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'; returns a '0'

Thanks..

George

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2000-10-31 21:58:17 Re: how good is PostgreSQL
Previous Message Adam Lang 2000-10-31 21:51:11 Re: postgres on redhat 7.0

Browse pgsql-sql by date

  From Date Subject
Next Message cn 2000-11-01 03:17:52 How To Increment A Field Value By Function
Previous Message K Parker 2000-10-31 19:42:22 RE: INSERT [IGNORE] INTO TABLE