PG_Exp_1.out

application/octet-stream

Filename: PG_Exp_1.out

Type: application/octet-stream

Part: 2

Message: Problem in 'ORDER BY' of a column using a created collation?

CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
CREATE COLLATION
 value1 | value2 
--------+--------
 a      | 1
 a      | 2
 a      | a
 a      | b
 b      | 1
 b      | 2
 b      | a
 b      | b
 1      | 1
 1      | 2
 1      | a
 1      | b
 2      | 1
 2      | 2
 2      | a
 2      | b
(16 rows)

 value1 | value2 
--------+--------
 1      | a
 2      | a
 a      | a
 b      | a
 1      | b
 2      | b
 a      | b
 b      | b
 1      | 1
 2      | 1
 a      | 1
 b      | 1
 1      | 2
 2      | 2
 a      | 2
 b      | 2
(16 rows)

DROP TABLE
DROP COLLATION