"Clodoaldo Pinto" <clodoaldo.pinto@xxxxxxxxx> 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