On Tue, Oct 10, 2023 at 2:44 AM Peter Eisentraut <pe...@eisentraut.org> wrote: > Can you restate what this is supposed to be for? This thread appears to > have morphed from "let's normalize everything" to "let's check for > unassigned code points", but I'm not sure what we are aiming for now.
Jeff can say what he wants it for, but one obvious application would be to have the ability to add a CHECK constraint that forbids inserting unassigned code points into your database, which would be useful if you're worried about forward-compatibility with collation definitions that might be extended to cover those code points in the future. Another application would be to find data already in your database that has this potential problem. -- Robert Haas EDB: http://www.enterprisedb.com