Re: select from composite type
От
David G. Johnston
Тема
Re: select from composite type
Дата
Msg-id
CAKFQuwbgspq1_jRD=zoB-k+NOJ4v0D3_XRFihGW5egcJB-u56Q@mail.gmail.com
Ответ на
Re: select from composite type (Adrian Klaver)
Список
Дерево обсуждения
select from composite type Lorusso Domenico <domenico.l76@gmail.com>
Re: select from composite type Adrian Klaver <adrian.klaver@aklaver.com>
Re: select from composite type "David G. Johnston" <david.g.johnston@gmail.com>
Re: select from composite type Lorusso Domenico <domenico.l76@gmail.com>
Re: select from composite type Lorusso Domenico <domenico.l76@gmail.com>
Re: select from composite type Adrian Klaver <adrian.klaver@aklaver.com>
On Sun, Feb 4, 2024 at 5:39 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> attribute_list is an array of composite type (with 20 fields).
I am trying to wrap my head around "array of composite type". Please
provide an example.
ARRAY[ (1,2)::point, (3,4)::point ]::point[]
The main problem is the concept of writing "from($1)" in any query makes no sense, you cannot parameterize a from clause directly like that. You have to put the value somewhere an expression is directly allowed.
David J.
В списке pgsql-general по дате отправления
