Re: Records, Types, and Arrays

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Raymond Brinzer <ray(dot)brinzer(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Records, Types, and Arrays
Date: 2023-05-19 06:58:36
Message-ID: CAKFQuwYs5-g-gk7q+KqQPBnEyVQkHHVa=W82akA9osm5hATQFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, May 18, 2023, Raymond Brinzer <ray(dot)brinzer(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Brinzer 2023-05-19 07:00:23 Re: Records, Types, and Arrays
Previous Message Raymond Brinzer 2023-05-19 06:48:10 Re: Records, Types, and Arrays