Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql function executed multiple times for each return value - Mailing list pgsql-sql

From David Johnston
Subject Re: plpgsql function executed multiple times for each return value
Date
Msg-id 4852CB86-2376-4A88-9B60-255FD9CFCDC3@yahoo.com
Whole thread Raw
In response to plpgsql function executed multiple times for each return value  (Steve Northamer <stevenorthamer@gmail.com>)
List pgsql-sql
Tree view

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.


pgsql-sql by date:

Previous
From: Steve Northamer
Date:
Subject: plpgsql function executed multiple times for each return value
Next
From: Tom Lane
Date:
Subject: Re: plpgsql function executed multiple times for each return value