Re: Records, Types, and Arrays - Mailing list pgsql-general

From David G. Johnston
Subject Re: Records, Types, and Arrays
Date
Msg-id CAKFQuwYs5-g-gk7q+KqQPBnEyVQkHHVa=W82akA9osm5hATQFg@mail.gmail.com
Whole thread Raw
In response to Re: Records, Types, and Arrays  (Raymond Brinzer <ray.brinzer@gmail.com>)
Responses Re: Records, Types, and Arrays  (Raymond Brinzer <ray.brinzer@gmail.com>)
List pgsql-general
On Thursday, May 18, 2023, Raymond Brinzer <ray.brinzer@gmail.com> wrote:

scratch=# select row(2,3)::test_type;

Unknown typed value, immediately converted to a known concrete instance of test_type. It is never actually resolved as record.

All of the others must concretely be resolved to record to escape their query level, and if you then try to cast the concrete record to some other concrete type a cast needs to exist.

David J.

pgsql-general by date:

Previous
From: Raymond Brinzer
Date:
Subject: Re: Records, Types, and Arrays
Next
From: Raymond Brinzer
Date:
Subject: Re: Records, Types, and Arrays