Postgres Pro
Downloads
Home   >   mailing lists

Re: select (fn()).* executes function multiple times - Mailing list pgsql-bugs

From Tom Lane
Subject Re: select (fn()).* executes function multiple times
Date
Msg-id 14745.1542380271@sss.pgh.pa.us
Whole thread Raw
In response to select (fn()).* executes function multiple times  (Andrey <parihaaraka@gmail.com>)
Responses Re: select (fn()).* executes function multiple times  (Andrey <parihaaraka@gmail.com>)
List pgsql-bugs
Tree view 
That's not a bug, that's just how it works.

You can get the other way with something like

SELECT f.* FROM ..., LATERAL fn(...) f;

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: select (fn()).* executes function multiple times
Next
From: Andrey
Date:
Subject: Re: select (fn()).* executes function multiple times