Postgres Pro
Downloads
Home   >   mailing lists

Thread: JSON_TABLE output collations

JSON_TABLE output collations

From
Peter Eisentraut
Date:
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.
Attachment

Re: JSON_TABLE output collations

From
Andrew Dunstan
Date:
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