Re: Calling the same function more than once with the same arguments

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com>
Cc: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Calling the same function more than once with the same arguments
Date: 2006-04-19 23:23:27
Message-ID: 5030.1145489007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Clodoaldo Pinto" <clodoaldo(dot)pinto(at)gmail(dot)com> writes:
> I'm building a function caller() in which a certain function called()
> will be called many times in from clauses with the same arguments and
> I'm wondering if is there a performance penalty for that or if the sql
> engine is smart enough to call called() only once.

No, it isn't.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-04-20 00:14:44 Re: How to implement a "subordinate database"?
Previous Message sconeek 2006-04-19 23:04:04 deleting table content through command prompt