Re: Transparent i18n?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: David Pratt <fairwinds(at)eastlink(dot)ca>
Cc: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transparent i18n?
Date: 2005-07-04 15:06:39
Message-ID: 87pstyvce8.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I wonder if you could make an SQL type that used text[] as its storage format
but had an output function that displayed the correct text for the "current
locale". Where "current locale" could be something you set by calling a
function at the beginning of the transaction.

Do pg_dump and all the important things use the send/receive functions not the
input/output functions? so even though this output function loses information
it wouldn't cause serious problems?

You would still need a way to retrieve all the languages for the cases like
administrative interfaces for updating the information. I'm not entirely
convinced this would be any better than the alternative of retrieving all of
them by default and having a function to retrieve only the correct language.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alejandro D. Burne 2005-07-04 15:13:27 Re: wrong sort order
Previous Message David Pratt 2005-07-04 13:29:45 Re: Transparent i18n?