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

From Pavel Stehule
Subject Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Date
Msg-id CAFj8pRBFePm8bQd_CJbyhf4f36iqZqO0x-PrFJLaZ=FmU+SUbA@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]  (Quan Zongliang <quanzongliang@yeah.net>)
Responses Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
List pgsql-hackers


pá 24. 11. 2023 v 2:12 odesílatel Quan Zongliang <quanzongliang@yeah.net> napsal:


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];

there were more issues in this part - the name "user_id" is a bad name for a composite variable.  I renamed it.
+ I wrote a test related to usage type without array support.

Now, I think so this simple patch is ready for committers

Regards

Pavel



Fixed.

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

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock
Next
From: Alena Rybakina
Date:
Subject: Re: POC, WIP: OR-clause support for indexes