MIME-Version: 1.0
References: <CAMon-aR07TWHZt2QX9QsZQEniyE-6+FdHJSGwyMwvegJSjjNug@mail.gmail.com>
 <0e67ba23-2531-4ade-8dce-12873f46601c@cloud.gatewaynet.com>
In-Reply-To: <0e67ba23-2531-4ade-8dce-12873f46601c@cloud.gatewaynet.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Tue, 22 Oct 2024 18:16:12 +0200
Message-ID: <CAFCRh-9zGSMPikqU8YSnexd4cKmtKKXiBuc60rOO2mS2NkuBHQ@mail.gmail.com>
Subject: Re: Regression in Postgres 17?
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-9zGSMPikqU8YSnexd4cKmtKKXiBuc60rOO2mS2NkuBHQ%40mail.gmail.com>
Precedence: bulk

On Tue, Oct 22, 2024 at 6:03=E2=80=AFPM Achilleas Mantzios
<a.mantzios@cloud.gatewaynet.com> wrote:
> =CE=A3=CF=84=CE=B9=CF=82 22/10/24 18:54, =CE=BF/=CE=B7 Colin 't Hart =CE=
=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> This works in Postgres 15:
> Do this instead :
> create function json_test(out value text, out jsonparam jsonb)
...
> apparently json is a reserved word (now) and won't be accepted as functio=
n parameter name.

Or properly double-quote the param name:

```
ddevienne=3D> show server_version;
 server_version
----------------
 17.0
(1 row)
                                                               ^
ddevienne=3D> create function json_test(out value text, out "json"
jsonb) returns record language sql as 'select null::text,
null::jsonb;';
CREATE FUNCTION
ddevienne=3D> select * from json_test();
 value | json
-------+------
       |
(1 row)
```