Re: JSON_TABLE output collations

2022-06-07 Thread Andrew Dunstan
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 attach

JSON_TABLE output collations

2022-06-07 Thread Peter Eisentraut
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