Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> 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