| From: | "Colin 't Hart" <colinthart(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Regression in Postgres 17? |
| Date: | 2024-10-22 15:54:29 |
| Message-ID: | CAMon-aR07TWHZt2QX9QsZQEniyE-6+FdHJSGwyMwvegJSjjNug@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
This works in Postgres 15:
pg15> create function json_test(out value text, out json jsonb)
returns record
language sql
as
$$
select null::text, null::jsonb;
$$
;
CREATE FUNCTION
pg15> select * from json_test();
┌───────┬──────┐
│ value │ json │
├───────┼──────┤
│ │ │
└───────┴──────┘
(1 row)
In Postgres 17 trying to create the function yields an error:
pg17> create function json_test(out value text, out json jsonb)
returns record
language sql
as
$$
select null::text, null::jsonb;
$$
;
ERROR: syntax error at or near "jsonb"
LINE 1: create function json_test(out value text, out json jsonb)
Am I doing something wrong? Or is this a regression?
Thanks,
Colin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Ross | 2024-10-22 16:00:17 | Re: Query performance issue |
| Previous Message | Rossana Ocampos | 2024-10-22 11:31:12 | CURRENTE_DATE |