Re: Regression in Postgres 17?

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)
```