Postgres Pro
Downloads
Home   >   mailing lists

Problem with coalesce.. - Mailing list pgsql-sql

From George Henry C. Daswani
Subject Problem with coalesce..
Date
Msg-id 006e01c04384$e4bb2d30$ee25012e@narn
Whole thread Raw
Responses Re: [GENERAL] Problem with coalesce..
List pgsql-sql
Tree view
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
 
 

pgsql-sql by date:

Previous
From: "K Parker"
Date:
Subject: RE: INSERT [IGNORE] INTO TABLE
Next
From: cn
Date:
Subject: How To Increment A Field Value By Function