Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3HDb-00BbOJ-VO for pgsql-general@arkaria.postgresql.org; Tue, 22 Oct 2024 15:54:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t3HDZ-000tkq-O2 for pgsql-general@arkaria.postgresql.org; Tue, 22 Oct 2024 15:54:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3HDZ-000thf-9Q for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 15:54:45 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t3HDX-002JJC-4b for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 15:54:44 +0000 Received: by mail-pj1-x1029.google.com with SMTP id 98e67ed59e1d1-2e2ad9825a7so3870385a91.0 for ; Tue, 22 Oct 2024 08:54:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729612481; x=1730217281; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=bEvtOSE2C9fHdQu6VQCuE8sqyr37BcsQ0zadnkFb7wU=; b=MQIsKN+FnO2t98e8RoI/p/TzgGT12+pLXan7Y21bfm53cI4jryiGMj1CmRfzyCQvQW NUC0VbD10W5hHBb/5Z7XL25lOa+x6wERbkBVu6b7SKXxbOjjEXuvb7/+sxigYtaQ0Czi Mcd9xE3yFt5kCasuUs4SpUne58O0zYO79Ax3yNv6i8LUX5Z/MJ6VpEck/H6ohkyo7sch d+j3i2B4Gn0nMMgfzmf3K47/yh01SbKLftxg4G1kwjiyS4N6muxeS6XZvMaFjyjIQUEj qGOZT5+ofL1U06/cRYeTqFjkk1U0S50ddPzbDeN+fCMH/Tz0SUCjwVKs/ZQRPyHpLt+d ztbw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729612481; x=1730217281; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=bEvtOSE2C9fHdQu6VQCuE8sqyr37BcsQ0zadnkFb7wU=; b=j8v4rPjOw3hPdp+mZkkG4j0wf7mZSO+GQn9Y1aA5lHPvBivtS9nREmbBJj0jPloImG Wm5oTyLBDUY9MCSKqweMeuOUdqZwb4zwTpjlEPXW8b8m7NPUZeZPTE6bcY+B76iCh97N 0ctPibRL4Ey4HvcvS9bXYUX+TW27xZXWyfrDUCpeFnrKOKLTUr3kjdwIJRVVhBWlWVtt TCZLMK6MYtZf0s0ZDUXaSr6IN7TmTgojwxmMc7yymc38zTVfdYsftLPWQb60qPZxfXVN HfvEDkRvh7wxRw3dPMmLZSI38fcuM4AXfjwJGagWUNwb4hAZ7ob8ihIuQTdlt6g9qJAm XZtQ== X-Gm-Message-State: AOJu0Yx0vu9sDcOjJhOJsTc7xGfNCsTt9uOeDGQOk8RfYLc8yXbCKqCu 7Z5jX7DX25k62KYHaq00eUBkWO47Qi8K+aA+FQtum854YAIc4nc2fyAE1TWJyWf7kjb9DDD1/Ho BRRbhjeNilY1or04Gu98fL66KbhyLSST2zPQ= X-Google-Smtp-Source: AGHT+IEYNWBs4MCPsvXJawQfrf5B77tgf2RzbO+l8d4VzGucPPmIy2PyFYJrSuKuGiloza2HhmWp4/MKDbFYNBXNYhE= X-Received: by 2002:a17:90b:360b:b0:2e0:8740:26d0 with SMTP id 98e67ed59e1d1-2e5615d701cmr17836174a91.2.1729612481374; Tue, 22 Oct 2024 08:54:41 -0700 (PDT) MIME-Version: 1.0 From: "Colin 't Hart" Date: Tue, 22 Oct 2024 17:54:29 +0200 Message-ID: Subject: Regression in Postgres 17? To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000008d3592062512c955" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008d3592062512c955 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 SGksDQoNClRoaXMgd29ya3MgaW4gUG9zdGdyZXMgMTU6DQoNCnBnMTU+IGNyZWF0ZSBmdW5jdGlv biBqc29uX3Rlc3Qob3V0IHZhbHVlIHRleHQsIG91dCBqc29uIGpzb25iKQ0KcmV0dXJucyByZWNv cmQNCmxhbmd1YWdlIHNxbA0KYXMNCiQkDQogIHNlbGVjdCBudWxsOjp0ZXh0LCBudWxsOjpqc29u YjsNCiQkDQo7DQpDUkVBVEUgRlVOQ1RJT04NCnBnMTU+IHNlbGVjdCAqIGZyb20ganNvbl90ZXN0 KCk7DQrilIzilIDilIDilIDilIDilIDilIDilIDilKzilIDilIDilIDilIDilIDilIDilJANCuKU giB2YWx1ZSDilIIganNvbiDilIINCuKUnOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKU gOKUgOKUgOKUgOKUpA0K4pSCICAgICAgIOKUgiAgICAgIOKUgg0K4pSU4pSA4pSA4pSA4pSA4pSA 4pSA4pSA4pS04pSA4pSA4pSA4pSA4pSA4pSA4pSYDQooMSByb3cpDQoNCg0KSW4gUG9zdGdyZXMg MTcgdHJ5aW5nIHRvIGNyZWF0ZSB0aGUgZnVuY3Rpb24geWllbGRzIGFuIGVycm9yOg0KDQpwZzE3 PiBjcmVhdGUgZnVuY3Rpb24ganNvbl90ZXN0KG91dCB2YWx1ZSB0ZXh0LCBvdXQganNvbiBqc29u YikNCnJldHVybnMgcmVjb3JkDQpsYW5ndWFnZSBzcWwNCmFzDQokJA0KICBzZWxlY3QgbnVsbDo6 dGV4dCwgbnVsbDo6anNvbmI7DQokJA0KOw0KRVJST1I6ICBzeW50YXggZXJyb3IgYXQgb3IgbmVh ciAianNvbmIiDQpMSU5FIDE6IGNyZWF0ZSBmdW5jdGlvbiBqc29uX3Rlc3Qob3V0IHZhbHVlIHRl eHQsIG91dCBqc29uIGpzb25iKQ0KDQoNCkFtIEkgZG9pbmcgc29tZXRoaW5nIHdyb25nPyBPciBp cyB0aGlzIGEgcmVncmVzc2lvbj8NCg0KVGhhbmtzLA0KDQpDb2xpbg0K --0000000000008d3592062512c955 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

This work= s in Postgres 15:

pg15> create function json_test(out value text,= out json jsonb)
returns record
language sql
as
$$
=C2=A0 se= lect null::text, null::jsonb;
$$
;
CREATE FUNCTION
pg15> sel= ect * from json_test();
=E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=AC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=90
=E2=94=82 value =E2=94=82 json =E2=94=82
=E2=94= =9C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=BC= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=A4
=E2=94= =82 =C2=A0 =C2=A0 =C2=A0 =E2=94=82 =C2=A0 =C2=A0 =C2=A0=E2=94=82
=E2=94= =94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=B4= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=98
<= div>(1 row)


= In Postgres 17 trying to create the function yields an error:
<= div>
pg17> create function json_test(out value tex= t, out json jsonb)
returns record
language sql
as
$$
=C2=A0 = select null::text, null::jsonb;
$$
;
ERROR: =C2=A0syntax error at = or near "jsonb"
LINE 1: create function json_test(out value te= xt, out json jsonb)
=

Am I doing something wrong? Or= is this a regression?

Thanks,

Colin
--0000000000008d3592062512c955--