Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] - Mailing list pgsql-hackers

From Quan Zongliang
Subject Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Date
Msg-id bbaba18e-ab18-4e19-9da8-117d3ce40330@yeah.net
Whole thread Raw
In response to Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
List pgsql-hackers

On 2023/11/24 03:39, Pavel Stehule wrote:

> 
> I modified the documentation a little bit - we don't need to extra 
> propose SQL array syntax, I think.
> I rewrote regress tests - we don't need to test unsupported 
> functionality (related to RECORD).
> 
> - all tests passed
> 
I wrote two examples of errors:
   user_id users.user_id%ROWTYPE[];
   user_id users.user_id%ROWTYPE ARRAY[4][3];

Fixed.

> Regards
> 
> Pavel
> 
> 
>      >
>      > Regards
>      >
>      > Pavel
>
Attachment

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: PATCH: Add REINDEX tag to event triggers
Next
From: Peter Smith
Date:
Subject: Re: pg_upgrade and logical replication