Re: Couldn't cast to record[] - Mailing list pgsql-general

From Tom Lane
Subject Re: Couldn't cast to record[]
Date
Msg-id 3162859.1646322496@sss.pgh.pa.us
Whole thread Raw
In response to Couldn't cast to record[]  (Suresh Kumar R <suresh.arsenal29@gmail.com>)
List pgsql-general
Suresh Kumar R <suresh.arsenal29@gmail.com> writes:
> When I query that table I need the pg_typeof(column) as record[] instead of
> composite_type[].

Why?  record[] is considered a pseudotype (polymorphic type),
which is why casting to it doesn't do anything.

            regards, tom lane



pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal