From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?0KY=?= <pfunk@mail.ru>
cc: =?UTF-8?B?RGF2aWQgRy4gSm9obnN0b24=?= <david.g.johnston@gmail.com>,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18443: jsonb_agg issue. Again.
In-reply-to: <1713547274.939623732@f335.i.mail.ru>
References: <18443-bd015c763e3196ca@postgresql.org>
 <CAKFQuwY4SWR6WqUp5DwauLMumJhr71+FFcY-qMFLFMqfq+fCzg@mail.gmail.com>
 <1713547274.939623732@f335.i.mail.ru>
Comments: In-reply-to =?UTF-8?B?0KY=?= <pfunk@mail.ru>
	message dated "Fri, 19 Apr 2024 20:21:14 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2176811.1713549143.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 19 Apr 2024 13:52:23 -0400
Message-ID: <2176812.1713549143@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2176812.1713549143%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?B?0KY=3D?=3D <pfunk@mail.ru> writes:
>> You wrote a table-producing function (one row but three columns).=C2=A0=
 Those need [1] to be executed in the FROM clause, via an implicit or expl=
icit LATERAL join if you have data from other relations being fed in as in=
put arguments.
>>
>> 1. well, at least if you don't want to see this kind of artifact where =
the way to expand .* is to copy the expression preceding it.

> Do you mean select=C2=A0(out3).* ..=C2=A0equal to=C2=A0select=C2=A0(out3=
).col1,=C2=A0(out3).col3,=C2=A0(out3).col3 =E2=80=A6=C2=A0?
> Didn`t even suppose that..
> Sometimes I've used (row).col or (row).*=C2=A0in select list.
> Would be appreciated if you could provide keywords for googling.

The main documentation about SELECT lists is

https://www.postgresql.org/docs/current/queries-select-lists.html

which points you to

https://www.postgresql.org/docs/current/rowtypes.html#ROWTYPES-USAGE

where there's a Tip explaining exactly this point.

			regards, tom lane