Context Navigation

Changes between Initial Version and Version 1 of Ticket #9682, comment 15

-              initial
+              v1
 to use POSIX  byte-order based collation.
+It'll be important to support the `COLLATE` clause for  index creation too. Otherwise users will get upset when their queries don't use the index that seems to be appropriate for the query.
+Most of the time it's best to specify `COLLATE` on a column in DDL, not in a query. That way queries using the column and indexes on the column automatically use the desired collation. You can "declare" a given column to be binary-sorted text where you don't care about national language collation.
+{{{
+CREATE TABLE some_table (
+    ....,
+    test_field text COLLATE "C",
+    ...
+);
+}}}
 I ''strongly'' recommend a solution using the `COLLATE` clause, but keep in mind that it's not a global query modifier. It affects the operator or `ORDER BY` clause it's attached to, not the whole query.