Merlin Moncure <mmoncure@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
