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

From: Quan Zongliang <quanzongliang(at)yeah(dot)net>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Date: 2023-11-24 01:11:59
Message-ID: bbaba18e-ab18-4e19-9da8-117d3ce40330@yeah.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
v20231124-0001-support-of-syntax-type-and-rowtype.patch text/plain 9.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2023-11-24 01:29:45 Re: pg_upgrade and logical replication
Previous Message jian he 2023-11-24 00:00:00 Re: PATCH: Add REINDEX tag to event triggers