Il 30/08/2012 4.01, Craig Ringer ha scritto:
On 08/28/2012 10:46 PM, Nicola Cisternino wrote:
1) Why PostgreSQL don't use COLLATE to manage case sensitive /
insensitive comparision (I think it's the best and ANSI standard way
....) ?
Support for per-column collations in PG was only added relatively
recently - in 9.1, by the looks:
http://www.postgresql.org/docs/9.1/static/collation.html
Prior to that, there was no meaningful way to use case insensitive
collations, as these would affect the whole database, including system
tables, which could break all sorts of things in new and exciting ways.
With the advent of per-column and per-operation collation control,
case-insensitive collations become very appealing.
One of the challenges with adding case insensitive collations is that,
AFAIK, collations are implemented using the operating system charset
and locale support, which may not offer case insensitive collation
directly.
Another challenge is the rather ... variable ... meaning of "case
insensitive". Results are likely to vary between host platforms and
versions.
Still, now that per-col / per-op collation is supported, it'd be nice
to have. I don't know if it's just a matter of needing someone with
the desire and time (or funding) and expertise to design and build it,
or if there'd be issues with getting it accepted.
--
Craig Ringer
Thus the problem is that " .... collations are implemented using the
operating system charset and locale support ... " while, other engines,
implements collations internally ..... is it right ?
Thanks.
