pgsql: Fix collation of JSON_TABLE output columns

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix collation of JSON_TABLE output columns
Date: 2022-06-10 04:18:33
Message-ID: E1nzW6S-003Yve-Nd@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix collation of JSON_TABLE output columns

The output columns of JSON_TABLE should have the collations of their
data type. The existing implementation sets the default collation if
the type is collatable.

Reviewed-by: Andrew Dunstan <andrew(at)dunslane(dot)net>
Discussion: https://www.postgresql.org/message-id/flat/9d75ce67-0121-5050-5bec-bf5009db55ce%40enterprisedb.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/21724558650a7387ffbc2b0da53d6314389419bb

Modified Files
--------------
src/backend/parser/parse_jsontable.c | 5 +----
1 file changed, 1 insertion(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2022-06-10 14:36:10 pgsql: Un-break whole-row Vars referencing domain-over-composite types.
Previous Message Etsuro Fujita 2022-06-09 10:35:55 pgsql: Improve comments for trivial_subqueryscan().