Re: 7.2.1: coalesce double-calls function? - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: 7.2.1: coalesce double-calls function?
Date
Msg-id 20030124153127.73831.qmail@web20805.mail.yahoo.com
Whole thread Raw
In response to 7.2.1: coalesce double-calls function?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-general
--- SZ�CS G�bor <surrano@mailbox.hu> wrote:
> It seems that COALESCE(myfunc(),0) has almost
> twice the time of
> calling myfunc() alone! However, using two
> COALESCE's in a CASE does not
> double the time again.
>

Perhaps this is just avoiding the issue (if indeed
there is an issue), but why not just define myfunc()
to return zero instead of null?

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql 7.3.1 crash
Next
From: "Nigel J. Andrews"
Date:
Subject: More PHP DB abstraction layer stuff