Horton

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

Gilles DAROLD <gilles@darold.net>

View thread View on postgr.es
From: Gilles Darold <gilles@darold.net>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2025-02-24T20:05:12Z
Lists: pgsql-hackers 
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,

-- 
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.