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

From SZŰCS Gábor
Subject Re: 7.2.1: coalesce double-calls function?
Date
Msg-id 015e01c2c3c3$0d69ed00$0a03a8c0@fejleszt2
Whole thread Raw
In response to 7.2.1: coalesce double-calls function?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-general
HAR HAR HAR! :)

Thanks for your kindness, I'll have a look at it....

... but don't hold your breath!

HAR HAR...

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: Friday, January 24, 2003 4:37 PM


> > CONCLUSION: I think both the optimizer, both the side effects would be
> > happier if all of COALESCE's expressions were only calculated once.
>
> Yup, and NULLIF too.  Want to submit a patch?  Look for CaseExpr in the
> sources, copy/paste/modify.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: Justin Clift
Date:
Subject: Re: More PHP DB abstraction layer stuff