Re: [GENERAL] PG-10 + ICU and abbreviated keys - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: [GENERAL] PG-10 + ICU and abbreviated keys
Date
Msg-id VisenaEmail.56.2bbb07f22fccd3a7.15fb720bc0b@tc7-visena
Whole thread Raw
In response to Re: [GENERAL] PG-10 + ICU and abbreviated keys  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-general
På mandag 13. november 2017 kl. 21:40:47, skrev Peter Geoghegan <pg@bowt.ie>:
On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh
<andreas@visena.com> wrote:
> Ok, so I have to explicitly specify like this:
>
> create table test(id serial primary key, name varchar collate "nb_NO" not null);

That doesn't look like an ICU locale. You may mean "nb-NO-x-icu". But
otherwise, yes.
 
 
Ok, is there a way I can get a list of ICU-collations?
 
 
> Will ICU be used here as long as PG is compiled with ICU-suppoert, as the debian-packages are, or do I have to specify collation-provider?

If you did initdb with a version with ICU support, the ICU collations
should be there.

> Do I have to explicitly specify collation when using ORDER by on that column for index and abbreviated keys to be used?

Only if you didn't define the column with a per-column collation initially.
 
Ok, thanks.
 
Looking forward to this being a per-database setting so it's (hopefully) more transparent.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] PG-10 + ICU and abbreviated keys
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: [GENERAL] PG-10 + ICU and abbreviated keys