Re: cast to domain with default collation issue.

On Monday, May 23, 2022, jian he <jian.universality@gmail.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.