Re: [SQL] plpgsql function executed multiple times for each return value

[David Johnston]

> So my questions are:  1) How do we cause the paymentcalc function to be 
> executed only once?  and 2) How do we call a table returning function with 
> inputs from a table?
> 
> Thank you very much!
> 
> Steve
> 

WITH func AS (
   SELECT FUNC(...) AS func_result FROM ...
)
SELECT (func.func_result).* FROM func

David J.