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

út 4. 3. 2025 v 0:04 odesílatel Tom Lane napsal: > Pavel Stehule writes: > >> po 24. 2. 2025 v 21:05 odesílatel Gilles Darold > >> napsal: > >>> I think it could be ready to be committed. > > Pushed with a docs/test correction: this also affects the syntax > of FOR-over-cursor. > > >>> Note for

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

Pavel Stehule writes: >> po 24. 2. 2025 v 21:05 odesílatel Gilles Darold >> napsal: >>> I think it could be ready to be committed. Pushed with a docs/test correction: this also affects the syntax of FOR-over-cursor. >>> Note for the committer: does it make sense to mention in the >>> documentat

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

Hi út 25. 2. 2025 v 6:32 odesílatel Pavel Stehule napsal: > Hi > > po 24. 2. 2025 v 21:05 odesílatel Gilles Darold > 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 curr

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

Hi po 24. 2. 2025 v 21:05 odesílatel Gilles Darold 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

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

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

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

Hi so 8. 2. 2025 v 22:25 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > so 8. 2. 2025 v 20:25 odesílatel Tom Lane napsal: > >> Is there any reason to think that that's actually in the standard? > > > I think the possibility to use named arguments in OPEN statements is a > > PostgreSQL

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

so 8. 2. 2025 v 22:25 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > so 8. 2. 2025 v 20:25 odesílatel Tom Lane napsal: > >> Is there any reason to think that that's actually in the standard? > > > I think the possibility to use named arguments in OPEN statements is a > > PostgreSQL pro

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

Pavel Stehule writes: > so 8. 2. 2025 v 20:25 odesílatel Tom Lane napsal: >> Is there any reason to think that that's actually in the standard? > I think the possibility to use named arguments in OPEN statements is a > PostgreSQL proprietary feature. > And usage of cursors in PL/pgSQL is based o

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

Hi so 8. 2. 2025 v 20:25 odesílatel Tom Lane napsal: > Pavel Stehule writes: > > I propose to enhancing to ANSI/SQL standard syntax for named arguments > > `argname => value` > > Is there any reason to think that that's actually in the standard? > I poked around in SQL:2021 a little and couldn'

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

Pavel Stehule writes: > I propose to enhancing to ANSI/SQL standard syntax for named arguments > `argname => value` Is there any reason to think that that's actually in the standard? I poked around in SQL:2021 a little and couldn't find anything about cursors with arguments at all.

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

Hi so 8. 2. 2025 v 11:27 odesílatel Japin Li napsal: > On Sat, 08 Feb 2025 at 16:34, Julien Rouhaud wrote: > > Hi, > > > > On Sat, Feb 08, 2025 at 07:47:23AM +0100, Pavel Stehule wrote: > >> Hi > >> > >> when I worked on strict expr check patch I found so syntax for named > >> arguments of curs

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

On Sat, 08 Feb 2025 at 16:34, Julien Rouhaud wrote: > Hi, > > On Sat, Feb 08, 2025 at 07:47:23AM +0100, Pavel Stehule wrote: >> Hi >> >> when I worked on strict expr check patch I found so syntax for named >> arguments of cursors supports only our legacy proprietary syntax `argname >> := value` >

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

Hi, On Sat, Feb 08, 2025 at 07:47:23AM +0100, Pavel Stehule wrote: > Hi > > when I worked on strict expr check patch I found so syntax for named > arguments of cursors supports only our legacy proprietary syntax `argname > := value` > > https://www.postgresql.org/docs/current/plpgsql-cursors.html

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

Hi when I worked on strict expr check patch I found so syntax for named arguments of cursors supports only our legacy proprietary syntax `argname := value` https://www.postgresql.org/docs/current/plpgsql-cursors.html I propose to enhancing to ANSI/SQL standard syntax for named arguments `argnam