Re: BUG #13799: Unexpected multiple exection of user defined function with out parameters

On Fri, Dec 4, 2015 at 11:36 PM, <mike(dot)lang1010(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 13799
> Logged by: Michael Lang
> Email address: mike(dot)lang1010(at)gmail(dot)com
> PostgreSQL version: 9.4.5
> Operating system: Ubuntu 12.04
> Description:
>
> Hi - it's late and I missed an typo in the previous submission of this bug.
> Please discard bug #13798 in favor of this post.
> ---
>

​Answers provided on original (#13798) bug report thread.

In short:

Use LATERAL
Use CTE (i.e., WITH) if unable or undesirable to use LATERAL​

​Using FROM works as long as you don't need to pass in parameters from
other relations. Typically this problem occurs when you do which is why
putting the function call into the SELECT list happens in the first place.​

David J.