Re: Couldn't cast to record[]

constant oid. With regards Suresh kumar R On Fri, 4 Mar, 2022, 11:28 pm Merlin Moncure, wrote: > On Thu, Mar 3, 2022 at 4:01 AM Suresh Kumar R > wrote: > > > > Hi, I created an table with composite type array as datatype for one > column. > > When I query that table I ne

Couldn't cast to record[]

Hi, I created an table with composite type array as datatype for one column. When I query that table I need the pg_typeof(column) as record[] instead of composite_type[]. I tried creating a separate function and returning record[], but below error is thrown, ERROR: PL/pgSQL functions cannot retur