pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Continuing Technical Education <CTE@Dal.Ca>
To: George Henry C. Daswani <gdaswani@esri.com>
Cc: Pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Problem with coalesce..
Date: Wed, 1 Nov 2000 11:01:22 -0400
Message-ID: <00a001c04414$997fd420$5911be86@cte.Dal.Ca> (raw)
References: <006e01c04384$e4bb2d30$ee25012e@narn>

Try:

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

  ----- Original Message ----- 
  From: George Henry C. Daswani 
  To: pgsql-sql@postgresql.org 
  Cc: pgsql-general@postgresql.org 
  Sent: Tuesday, October 31, 2000 5:52 PM
  Subject: [SQL] Problem with coalesce..


  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

view thread (4+ messages)  latest in thread

Message-ID: <00a001c04414$997fd420$5911be86@cte.Dal.Ca>
Permalink:  ../00a001c04414$997fd420$5911be86@cte.Dal.Ca/
Also on:    postgresql.org/message-id/00a001c04414$997fd420$5911be86@cte.Dal.Ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: CTE@Dal.Ca, gdaswani@esri.com
  Subject: Re: Problem with coalesce..
  In-Reply-To: <00a001c04414$997fd420$5911be86@cte.Dal.Ca>
  References: <006e01c04384$e4bb2d30$ee25012e@narn> <00a001c04414$997fd420$5911be86@cte.Dal.Ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox