Re: picking the correct locale when doing initdb - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: picking the correct locale when doing initdb
Date
Msg-id 20060317161314.GB7887@svana.org
Whole thread Raw
In response to Re: picking the correct locale when doing initdb  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On Thu, Mar 16, 2006 at 09:21:56PM -0500, Greg Stark wrote:
> In any case having actually implemented multilingual sites I can't imagine one
> locale per table being useful at all. You always end up wanting per column,
> even per array element locales.

Exactly, in the SQL standard it's referred to an COLLATE and it has
fairly detailed rules about how to deal with cross-column comparisons.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: \copy combine with SELECT
Next
From: Scott Marlowe
Date:
Subject: Re: each line counter