Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Well, it won't make it harder to implement collations; but I worry that
people who have been relying on the citext syntax will have a hard time
migrating to collations.  Perhaps if someone did the legwork to
determine exactly what that conversion would look like, it would assuage
the fear.

I kind of assumed we would do it by implementing the COLLATE clause of the CREATE DOMAIN statement.

But to define such a domain, you'd have to commit to a case-insensitive
version of a specific collation, no?  citext currently means "case
insensitive version of whatever the database's default collation is".
This might be worrying over nothing significant, but I'm not
convinced...

                        

Well, that's all we've got right now.

Presumably as David says we could leave citext sitting in contrib for compatibility reasons, once we get more fine-grained collation support.

I guess, too, we can add all sorts of warnings about citext not being future-proof.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to