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

Quan Zongliang <quanzongliang@yeah.net>

View thread

From: Quan Zongliang <quanzongliang@yeah.net>

To: Pavel Stehule <pavel.stehule@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2023-11-24T01:11:59Z

Lists: pgsql-hackers

Attachments

v20231124-0001-support-of-syntax-type-and-rowtype.patch (text/plain) patch v20231124-0001


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
>

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Clean up some edge cases in plpgsql's %TYPE parsing.
- 43b46aae12b2 17.0 landed
In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration.
- 5e8674dc8392 17.0 landed