Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-sql by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group