Re: cast to domain with default collation issue.

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

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