Re: problem with overloading the "coalesce" function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Emil Rachovsky <zsevgymko(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: problem with overloading the "coalesce" function
Date: 2006-03-07 02:39:18
Message-ID: 12236.1141699158@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Richard Huxton <dev(at)archonet(dot)com> writes:
> Hmm - looking at the source (and \df in psql) it seems the basic problem
> is that COALESCE() isn't a function.

If it were an ordinary function, it couldn't satisfy the property of not
evaluating "unused" arguments ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-07 03:04:26 Re: ERROR: xlog flush request not satisfied
Previous Message Chris 2006-03-07 02:06:53 Re: How to determine the table a query or a views columns

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-03-08 12:07:27 Re: [SQL] Interval subtracting
Previous Message Michael Fuhr 2006-03-06 18:30:42 Re: Syntax error in Execute statement