Re: WIP patch for LATERAL subqueries

Merlin Moncure <mmoncure(at)gmail(dot)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