Merlin Moncure <mmonc...@gmail.com> writes: > This is just awesome. Anyways, I was looking around the docs for > references to the old methodology of select list SRF function calls. > This paragraph: > http://www.postgresql.org/docs/devel/static/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET
> could probably use some enhancement describing best practices in a > LATERAL world and more examples of dealing with set returning > functions in general. Done, thanks for the suggestion. > I also noticed that the build in SRF page > (http://www.postgresql.org/docs/devel/static/functions-srf.html) lies > with the comment "This section describes functions that possibly > return more than one row. Currently the only functions in this class > are series generating functions" since at minimum we have 'unnest' so > that page could use some wordsmithing as well. Yeah, there's also some regexp-related SRFs, as well as a boatload of built-in SRFs that are mainly meant to underlie views. I guess we could try to force all of those into this page, but it doesn't really seem like it'd be an improvement. I took out the claim that these were all such functions, instead. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers