Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrey
Subject Re: select (fn()).* executes function multiple times
Date
Msg-id CAOYf6eey0Ged+oLhL6W=r+fGT9Z1OiEpcFR0_EXKUKrR3fbaAA@mail.gmail.com
Whole thread Raw
In response to Re: select (fn()).* executes function multiple times  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
O_o
I got it. Sorry for disturbing you.
Thanks

regards, Andrey L

пт, 16 нояб. 2018 г. в 17:57, Tom Lane <tgl@sss.pgh.pa.us>:
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: Tom Lane
Date:
Subject: Re: select (fn()).* executes function multiple times
Next
From: PG Bug reporting form
Date:
Subject: BUG #15510: Anytime I boot my iMac Safari gets started and showsPgAdmin 4 page