Dmitry Koterov wrote:
One difference in SQL syntax is that FireBird could join stored
procedures like this:
SELECT b.*
FROM
get_ids() a
LEFT JOIN get_data(a.ID <http://a.ID>) ON 1=1
(where a.ID <http://a.ID> parameter is passed from the previous set as
a next procedure parameter), but Postgres cannot.
Can't PostgreSQL do that now though?
Functions with out params are treated like tables as of 8.1.
Later,
Tony
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
