Re: UNNEST with multiple args, and TABLE with multiple funcs
От | Andrew Gierth |
---|---|
Тема | Re: UNNEST with multiple args, and TABLE with multiple funcs |
Дата | |
Msg-id | 87eh68vbvm.fsf@news-spur.riddles.org.uk обсуждение исходный текст |
Ответ на | Re: UNNEST with multiple args, and TABLE with multiple funcs (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: UNNEST with multiple args, and TABLE with multiple funcs
|
Список | pgsql-hackers |
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes: Tom> I've committed this patch after some significant editorialization, butTom> leaving the use of TABLE( ... ) syntax in-place. If we decide that weTom> don't want to risk doing that, we can change to some other syntax later. Is this intended: create function foo() returns setof footype language plpgsql as $f$ begin return next row(1,true); end; $f$; select pg_typeof(f), row_to_json(f) from foo() with ordinality f(p,q);pg_typeof | row_to_json -----------+---------------------------------record | {"p":1,"q":true,"ordinality":1} (1 row) select pg_typeof(f), row_to_json(f) from foo() f(p,q);pg_typeof | row_to_json -----------+------------------footype | {"a":1,"b":true} (1 row) -- Andrew (irc:RhodiumToad)
В списке pgsql-hackers по дате отправления: