domain check constraint should also consider domain's collation - Mailing list pgsql-hackers

From jian he
Subject domain check constraint should also consider domain's collation
Date
Msg-id CACJufxGpnsOWHmgQVSRidevZ-4obuaGXAuJES+9QvCYupT4q7g@mail.gmail.com
Whole thread Raw
List pgsql-hackers
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 constraint not satisfied?

If so, attached is the POC trying to implement it.

Attachment

pgsql-hackers by date:

Previous
From: Alexander Kukushkin
Date:
Subject: Re: Requested WAL segment xxx has already been removed
Next
From: Mankirat Singh
Date:
Subject: Re: ABI Compliance Checker GSoC Project