public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: Achilleas Mantzios <[email protected]>
Cc: [email protected]
Subject: Re: Regression in Postgres 17?
Date: Tue, 22 Oct 2024 18:16:12 +0200
Message-ID: <CAFCRh-9zGSMPikqU8YSnexd4cKmtKKXiBuc60rOO2mS2NkuBHQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAMon-aR07TWHZt2QX9QsZQEniyE-6+FdHJSGwyMwvegJSjjNug@mail.gmail.com>
	<[email protected]>

On Tue, Oct 22, 2024 at 6:03 PM Achilleas Mantzios
<[email protected]> 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)
```

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Regression in Postgres 17?
  In-Reply-To: <CAFCRh-9zGSMPikqU8YSnexd4cKmtKKXiBuc60rOO2mS2NkuBHQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox