Postgres Pro
Downloads
Home   >   mailing lists

JSON_TABLE output collations - Mailing list pgsql-hackers

From Peter Eisentraut
Subject JSON_TABLE output collations
Date
Msg-id 9d75ce67-0121-5050-5bec-bf5009db55ce@enterprisedb.com
Whole thread Raw
Responses Re: JSON_TABLE output collations
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: docs: mention "pg_read_all_stats" in "track_activities" description
Next
From: Jakub Wartak
Date:
Subject: RE: effective_io_concurrency and NVMe devices