Postgres Pro
Downloads
Home   >   mailing lists

Re: JSON_TABLE output collations - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: JSON_TABLE output collations
Date
Msg-id 80775d2e-24b5-378b-7f4b-664e34efc85d@dunslane.net
Whole thread Raw
In response to JSON_TABLE output collations  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
Tree view 
On 2022-06-07 Tu 09:19, Peter Eisentraut wrote:
>
> The present implementation of JSON_TABLE sets the collation of the
> output columns to the default collation if the specified data type is
> collatable.  Why don't we use the collation of the type directly? 
> This would make domains with attached collations work correctly.
>
> See attached patch for how to change this.  I hacked up a regression
> test case to demonstrate this.



Looks reasonable.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: vignesh ravichandran
Date:
Subject: Re: pg_rewind: warn when checkpoint hasn't happened after promotion
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: How about a psql backslash command to show GUCs?