Glenn Maynard <glennfmaynard@xxxxxxxxx> writes: > http://www.postgresql.org/docs/8.3/static/xfunc-sql.html says this is > deprecated (though no deprecation warning is being generated): >> Currently, functions returning sets can also be called in the select list of a query. For each row that the query generates by itself, the function returning set is invoked, and an output row is generated for each element of the function's result set. Note, however, that this capability is deprecated and might be removed in future releases. The way to parse that is "we don't like this and we will get rid of it if we can ever figure out a good substitute". Right now there is no 100% substitute, so it stays. (In fact, 8.4 will extend the feature so it works in cases that don't work today, like for PL functions.) There are, however, good reasons not to like it, such as the rather questionable behavior if there's more than one SRF in the same select list. Don't complain if you run into that wart. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
