Re: [WIP] patch - Collation at database level

Andrew Dunstan napsal(a):
> 
> 
> Tom Lane wrote:
>>
>> All the argument here is based on the premise that we should have
>> database-level collation specifications, which AFAICS is not required
>> nor suggested by the SQL spec.  I wonder why we are allowing a
>> nonstandard half-measure to drive our thinking, rather than solving the
>> real problem which is column-level collations.
>>
>>
>>   
> 
> Agreed. Are we even sure that we want per-database collations as a 
> half-way house? Unless we can be sure that we want all the required 
> catalog changes for the full requirement, it seems to me a rather messy 
> way of getting to where we want to go.

Andrew,
I would like also to see full collation implementation rather then collation per 
database. But from my point of view split collation into small parts is much 
better. Radek's work is mostly about creating infrastructure for full collation 
support. When it will be finished, then "only" changes in parser, executor... 
will be necessary to complete a job.

If you look on most discussion about collation they fell into ICU yes/no problem 
without any real decision how to implemented the feature.
    Zdenek


-- 
Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql