Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: plpgsql function executed multiple times for each return value
Date
Msg-id 11372.1318091521@sss.pgh.pa.us
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 
Steve Northamer <stevenorthamer@gmail.com> writes:
> So my questions are:  1) How do we cause the paymentcalc function to be 
> executed only once?

In recent versions, I think marking it volatile would be sufficient.
        regards, tom lane

pgsql-sql by date:

Previous
From: David Johnston
Date:
Subject: Re: plpgsql function executed multiple times for each return value
Next
From: "F. BROUARD / SQLpro"
Date:
Subject: [GENERAL] Creating rule for sliding data