On 2014-06-17 21:09:25 +0530, Abhijit Menon-Sen wrote: > At 2014-06-17 11:32:37 -0400, br...@momjian.us wrote: > > > > > SRFs in the SELECT targetlist tend to leak memory; this is not easily > > > fixable, and nobody is likely to try hard considering the feature's on > > > the edge of deprecation anyhow. > > > > Uh, what is replacing SRFs? CTEs? > > I don't think Tom was referring to SRFs in general, only putting them > directly into the targetlist of a SELECT.
And the primary reason for using SRFs in the targetlist has gone away due to LATERAL. It's now possible to pass data from tables to a SRF, that previously wasn't possibly unless you'd used a SRF in the targetlist. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers