Re: Table function support
От | Tom Lane |
---|---|
Тема | Re: Table function support |
Дата | |
Msg-id | 4221.1176243434@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Table function support ("Pavel Stehule" <pavel.stehule@hotmail.com>) |
Ответы |
Re: Table function support
Re: Table function support |
Список | pgsql-patches |
"Pavel Stehule" <pavel.stehule@hotmail.com> 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 по дате отправления: