Re: Regression in Postgres 17? - Mailing list pgsql-general

On Tue, Oct 22, 2024 at 6:03 PM Achilleas Mantzios
<a.mantzios@cloud.gatewaynet.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)
```