Postgres Pro
Downloads
Home   >   mailing lists

Re: Calling the same function more than once with the same arguments - Mailing list pgsql-general

From Tom Lane
Subject Re: Calling the same function more than once with the same arguments
Date
Msg-id 5030.1145489007@sss.pgh.pa.us
Whole thread Raw
In response to Calling the same function more than once with the same arguments  ("Clodoaldo Pinto" <clodoaldo.pinto@gmail.com>)
Responses Re: Calling the same function more than once with the  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view 
"Clodoaldo Pinto" <clodoaldo.pinto@gmail.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

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Calling the same function more than once with the same
Next
From: Orion
Date:
Subject: locating a primary key