Re: 7.2.1: coalesce double-calls function?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: SZŰCS Gábor <surrano(at)mailbox(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2.1: coalesce double-calls function?
Date: 2003-01-24 15:37:29
Message-ID: 13346.1043422649@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano(at)mailbox(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2003-01-24 15:39:40 OT: cvsweb (was: psql 7.3.1 crash)
Previous Message Nigel J. Andrews 2003-01-24 15:35:28 More PHP DB abstraction layer stuff