Re: Table function support
От
Tom Lane
Тема
Re: Table function support
Дата
Msg-id
4221.1176243434@sss.pgh.pa.us
Ответ на
Table function support (Pavel Stehule)
Список
Дерево обсуждения
Re: Table function support "Pavel Stehule" <pavel.stehule@hotmail.com>
"Pavel Stehule" writes: > this patch allows using SQL2003 syntax for set returning functions. It is > based on using new type of argmode - PROARGMODE_TABLE. I've been looking at this, and my feeling is that we should drop the PROARGMODE_TABLE business and just define RETURNS TABLE(x int, y int) as exactly equivalent to RETURNS SETOF RECORD with x and y treated as OUT parameters. There isn't any advantage to distinguishing the cases that outweighs breaking client code that looks at pg_proc.proargmodes. I don't believe that the SQL spec prevents us from exposing those parameter names to PL functions, especially since none of our PLs are in the standard at all. regards, tom lane
В списке pgsql-patches по дате отправления