Re: [HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2014-01-21 Thread Alvaro Herrera
Craig Ringer wrote: (I intensely dislike the idea of ignoring accents, but it's something some people appear to need/want, and is supported by other vendors). FWIW at least in spanish, users always want to search for entries ignoring accents. Nowadays I think most turn to unaccent(), but

Re: [HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2014-01-21 Thread Pavel Stehule
This feature is interesting for Czech language too. Lot of applications allows accent free searching due possible issues in original data or some client limits - missing Czech keyboard and similar Dne 21.1.2014 17:17 Alvaro Herrera alvhe...@2ndquadrant.com napsal(a): Craig Ringer wrote: (I

[HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2013-12-29 Thread Craig Ringer
One of the big appeals of the new COLLATE feature was, to me, the possibility that we'd be able to support custom collations including case-insensitive collations in future. It's something I'd like to tackle one day, and in the mean time want to pop on the TODO so it's not lost and forgotten.

Re: [HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2013-12-29 Thread Craig Ringer
On 12/30/2013 08:49 AM, Craig Ringer wrote: One of the big appeals of the new COLLATE feature was, to me, the possibility that we'd be able to support custom collations including case-insensitive collations in future. It's something I'd like to tackle one day, and in the mean time want to