Re: cast to domain with default collation issue.

On Monday, May 23, 2022, jian he <jian(dot)universality(at)gmail(dot)com> wrote:

> CREATE DOMAIN testdomain AS text;
>
> --asume the default collation is as per show LC_COLLATE;
>
> – on my pc, it is C.UTF-8.
>
> --So the testdomain will be collation "C.UTF-8"
> ------------
>
> => \d collate_test1
>
> Table "test.collate_test1"
>
> Column | Type | Collation | Nullable | Default
>
> --------+---------+-----------+----------+---------
>
> a | integer | | |
>
> b | text | en-x-icu | not null |
>
> -----------------------------------------------
>
> My guess is that the following should be the same.
>
>
>
My reading of the docs say this is consistent with outcome #2.

https://www.postgresql.org/docs/current/collation.html

David J.