Re: contrib/citext versus collations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org, "David E(dot) Wheeler" <david(at)kineticode(dot)com>, lr(at)pcorp(dot)us
Subject: Re: contrib/citext versus collations
Date: 2011-06-08 19:26:42
Message-ID: 2837.1307561202@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> On further reflection, I'm wondering exactly how much goodness to chop
> off there. What I'd originally been thinking was to just lobotomize the
> case-folding step, and allow citext's comparison operators to still
> respond to input collation when comparing the folded strings. However,
> I can imagine that some combinations of languages might produce pretty
> weird results if we do that. Should we lobotomize the comparisons too?
> Or is the ability to affect the sort order valuable enough to put up
> with whatever corner-case funnies there might be?

For lack of any comment on this point, I went with the first approach.
Patch is committed.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-06-08 19:30:31 Re: could not truncate directory "pg_serial": apparent wraparound
Previous Message Tom Lane 2011-06-08 19:05:09 Re: gcc 4.6 and hot standby