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

Quan Zongliang <quanzongliang@yeah.net>

From: Quan Zongliang <quanzongliang@yeah.net>

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

Date: 2023-10-17T01:19:29Z

Lists: pgsql-hackers

Attachments

plpgsql-typearr-v2.patch (text/plain) patch v2

Attached new patch
   More explicit error messages based on type.


On 2023/10/16 18:15, Quan Zongliang wrote:
> 
> 
> Implement TODO item:
> PL/pgSQL
> Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
> 
> As a first step, deal only with [], such as
> xxx.yyy%TYPE[]
> xxx%TYPE[]
> 
> It can be extended to support multi-dimensional and complex syntax in 
> the future.
> 
> 
> -- 
> Quan Zongliang

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