yql/essentials/tests/sql/suites/pg/collate_std.sql


1
2
3
4
5
6
7
8
9
10
11
12

--!syntax_pg
select
    upper('straße' COLLATE "default"),
    upper('straße' COLLATE "C"),
    upper('straße' COLLATE "POSIX"),
    upper('straße' COLLATE "ucs_basic"),
    upper('straße' COLLATE "unicode"),
    upper('i' COLLATE "default"),
    upper('i' COLLATE "C"),
    upper('i' COLLATE "POSIX"),
    upper('i' COLLATE "ucs_basic"),
    upper('i' COLLATE "unicode");