Re: domain check constraint should also consider domain's collation

2025-07-14 Thread Tom Lane
jian he writes: > CREATE COLLATION case_insensitive (provider = icu, locale = > '@colStrength=secondary', deterministic = false); > SELECT 'a' = 'A' COLLATE case_insensitive; > CREATE DOMAIN d1 as text collate case_insensitive check (value <> 'a'); > SELECT 'A'::d1; > ``SELECT 'A'::d1`` should er

domain check constraint should also consider domain's collation

2025-07-14 Thread jian he
hi. CREATE COLLATION case_insensitive (provider = icu, locale = '@colStrength=secondary', deterministic = false); SELECT 'a' = 'A' COLLATE case_insensitive; CREATE DOMAIN d1 as text collate case_insensitive check (value <> 'a'); SELECT 'A'::d1; ``SELECT 'A'::d1`` should error out as domain check