Re: picking the correct locale when doing initdb

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "Tomi NA" <hefest(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: picking the correct locale when doing initdb
Date: 2006-03-17 02:21:56
Message-ID: 878xr9olob.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Tomi NA" <hefest(at)gmail(dot)com> writes:

> Here's an idea: let's make the locale a table-level setting, settable at
> table creation time so that it's concievable to use postgresql to build,
> say, a turist information site supporting english, german, spanish and
> italian at the same time.

Which locale would you use to perform comparisons for table joins?

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.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-03-17 03:11:19 Re: full text indexing
Previous Message Robert Treat 2006-03-17 00:05:11 Re: will slony work for this ?