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
