File: 3-collations.sql

package info (click to toggle)
pgcopydb 0.17-1
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 30,636 kB
  • sloc: ansic: 217,474; sql: 1,654; sh: 812; makefile: 365; python: 94
file content (19 lines) | stat: -rw-r--r-- 350 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
create table colls
 (
   id bigserial not null primary key,
   f1 text collate "fr-FR-x-icu",
   f2 text collate "de-DE-x-icu"
 );

create collation if not exists mycol
 (
   locale = 'fr-FR-x-icu',
   provider = 'icu'
 );

create table mycoltab
 (
   id bigserial not null primary key,
   f1 text collate mycol,
   f2 text collate "en-US-x-icu"
 );