Re: select from composite type - Mailing list pgsql-general

From David G. Johnston
Subject Re: select from composite type
Date
Msg-id CAKFQuwbgspq1_jRD=zoB-k+NOJ4v0D3_XRFihGW5egcJB-u56Q@mail.gmail.com
Whole thread Raw
In response to Re: select from composite type  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: select from composite type  (Lorusso Domenico <domenico.l76@gmail.com>)
List pgsql-general
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: select from composite type
Next
From: "Pete O'Such"
Date:
Subject: bug/confusion with pg_log_standby_snapshot()