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(at)sss(dot)pgh(dot)pa(dot)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.