Horton

Re: proposal - plpgsql - support standard syntax for named arguments for cursors

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Gilles Darold <gilles@darold.net>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2025-02-25T05:32:37Z
Lists: pgsql-hackers 
Hi

po 24. 2. 2025 v 21:05 odesílatel Gilles Darold <gilles@darold.net> napsal:

> Review:
>
> This patch claims to add SQL/PSM named arguments syntax to cursors and
> this what it does exactly.
>
>   It compiles without error with master current code and all tests
> passed successfully.
>
> I think it could be ready to be committed.
>
>
> Note for the committer: does it make sense to mention in the
> documentation that this standard SQL/PSM syntax is preferred than the PG
> syntax?
>

>
> Best regards,
>

Thank you for review

Pavel


>
> --
> Gilles Darold
> http://www.darold.net/
>
>

Commits

  1. Allow => syntax for named cursor arguments in plpgsql.

  2. Allow named parameters to be specified using => in addition to :=

  3. Add support for passing cursor parameters in named notation in PL/pgSQL.