From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
---|---|
To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Regression in Postgres 17? |
Date: | 2024-10-22 16:16:12 |
Message-ID: | CAFCRh-9zGSMPikqU8YSnexd4cKmtKKXiBuc60rOO2mS2NkuBHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Oct 22, 2024 at 6:03 PM Achilleas Mantzios
<a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
> Στις 22/10/24 18:54, ο/η Colin 't Hart έγραψε:
> 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 function parameter name.
Or properly double-quote the param name:
```
ddevienne=> show server_version;
server_version
----------------
17.0
(1 row)
^
ddevienne=> create function json_test(out value text, out "json"
jsonb) returns record language sql as 'select null::text,
null::jsonb;';
CREATE FUNCTION
ddevienne=> select * from json_test();
value | json
-------+------
|
(1 row)
```
From | Date | Subject | |
---|---|---|---|
Next Message | Durgamahesh Manne | 2024-10-22 18:58:06 | Lock contention issues with repack |
Previous Message | Tom Lane | 2024-10-22 16:12:46 | Re: Regression in Postgres 17? |