Re: type bug?
От
David G. Johnston
Тема
Re: type bug?
Дата
Msg-id
CAKFQuwYkgko2vHc=iXfAqFytCztYoOXyJ_52ewjbcMRtzHusMg@mail.gmail.com
Ответ на
type bug? (ml@ft-c.de)
Список
Дерево обсуждения
type bug? ml@ft-c.de
Re: type bug? Ron <ronljohnsonjr@gmail.com>
Re: type bug? ml@ft-c.de
Re: type bug? Pavel Stehule <pavel.stehule@gmail.com>
Re: type bug? "David G. Johnston" <david.g.johnston@gmail.com>
Re: type bug? "David G. Johnston" <david.g.johnston@gmail.com>
On Tuesday, October 5, 2021, <ml@ft-c.de> wrote:
select * from test_xyz2() ; -- 3 columns, but 1 should be correct?
select b from test_xyz2() ; -- error
select x from test_xyz2() ; -- never declared column
All three of these stem from:
If the function is defined to return a composite type, the table function produces a column for each attribute of the composite type.
Table(composite) == “setof composite”. (Though it seems to not be explicitly documented in that way, it explains the observed behavior)
David J.
В списке pgsql-general по дате отправления
