Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: 7.2.1: coalesce double-calls function?
Date
Msg-id 13346.1043422649@sss.pgh.pa.us
Whole thread Raw
In response to 7.2.1: coalesce double-calls function?  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Responses Re: 7.2.1: coalesce double-calls function?  (Kris Jurka <books@ejurka.com>)
List pgsql-general
Tree view 
"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> 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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: More PHP DB abstraction layer stuff
Next
From: Tom Lane
Date:
Subject: Re: pid in pg_locks not present in procpid pg_stat_activity