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