| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
| Cc: | Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Per-column collation |
| Date: | 2010-12-06 19:29:38 |
| Message-ID: | 1291663779.10677.31.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On mån, 2010-12-06 at 10:01 -0800, David E. Wheeler wrote:
> I've been wondering if this patch will support case-insensitve
> collations. If so, then citext should probably be revised to use one.
This has been touch upon several times during the discussions on past
patches.
Essentially, the current patch only arranges that you can specify a sort
order for data. The system always breaks ties using a binary
comparison. This could conceivably be changed, but it's a separate
problem. Some of the necessary investigation work has presumably
already been done in the context of citext.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-12-06 19:36:04 | Re: pg_execute_from_file review |
| Previous Message | Peter Eisentraut | 2010-12-06 19:26:48 | Re: Per-column collation |