På onsdag 13. januar 2016 kl. 00:03:18, skrev Tom Lane <t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh <andr...@visena.com> writes: > What about ORDER BY on columns without an index, would they sort correctly?
Sorting is sorting, it'll just use whatever collation is specified or implied. regards, tom lane Right, so poking with pg_database.datcollate would take care of that so no explicit COLLATE has to be issued on ORDER BY? -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
