On Wed, Jul 20, 2016 at 10:38 PM, Bruce Momjian <br...@momjian.us> wrote: > SELECT 'a-c' AS x UNION ALL SELECT 'ab' AS x ORDER BY x COLLATE "C";
::***> select 'a-c' COLLATE "C" AS x UNION ALL SELECT 'ab' AS x ORDER BY x ; ┌─────┐ │ x │ ├─────┤ │ a-c │ │ ab │ └─────┘ (2 rows) But I think I agree that it's surprising that the collate clause isn't working in the ORDER BY on a column produced by a UNION. Certainly that's where people usually want to put it. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
