Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42265=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WODAV-0002v7-7t
 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Mar 2014 21:27:59 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42265=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WODAU-0008N1-OS
 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Mar 2014 21:27:58 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cs_dba@consistentstate.com>) id 1WODAT-0008Mn-Tw
 for pgsql-admin@postgresql.org; Thu, 13 Mar 2014 21:27:58 +0000
Received: from mail-ie0-f174.google.com ([209.85.223.174])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <cs_dba@consistentstate.com>) id 1WODAR-0001HB-8S
 for pgsql-admin@postgresql.org; Thu, 13 Mar 2014 21:27:57 +0000
Received: by mail-ie0-f174.google.com with SMTP id rp18so1639539iec.5
 for <pgsql-admin@postgresql.org>; Thu, 13 Mar 2014 14:27:54 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
 :subject:content-type:content-transfer-encoding;
 bh=1OrF0g8KBLT9DP7rL6ypB5/CY02AuAmBS44gbEPw9nU=;
 b=cfH/cZkg+eaA90eVcMSMRuxmfVCs2uQ9By8DQnfdkX6IZDgAMF2Sp63qd7Iagn4HOy
 ik2xDSkmtPQ/WljaMoO7QmY2mCWoQ8E6vUXeAT2wiCCiDT/Qujos1Sdlw/NaDKPD/0tr
 jTbD9Qi6jytogCxVy1C2AZWRM06XmKumwgTu6PdTqt1bVci0PYuNjRRh61yJzbIOkoT3
 d9kSOCBBLvAtX1Vvdl6Q+UduyPKob8fwD8RJScsynlHiDLoeuze/mkAqjxJKyQZkClXk
 opoNL0p/J3zVwSoYfPMakFHS15rhTWxPGtpfw9b811qROE8eMzLt2jc17hPZJYjZtilj
 Nw3w==
X-Gm-Message-State: 
 ALoCoQnrqWpTE8kV75dI3lTc5gDYWGXdz0Of6rP0X+OxP/g174X2kPpyvsS04wCEq9h+0EKPLKUZ
X-Received: by 10.43.156.18 with SMTP id lk18mr3425034icc.77.1394746074058;
 Thu, 13 Mar 2014 14:27:54 -0700 (PDT)
Received: from fedora20.consistentstate.com
 (50-203-217-122-static.hfc.comcastbusiness.net. [50.203.217.122])
 by mx.google.com with ESMTPSA id vu3sm12226624igc.6.2014.03.13.14.27.52
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Thu, 13 Mar 2014 14:27:53 -0700 (PDT)
Message-ID: <532222D7.2000006@consistentstate.com>
Date: Thu, 13 Mar 2014 15:27:51 -0600
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Internationalization
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi All;

we want to store data in a generic fashion (COLLATION / ENCODING?)

and then define on the fly which language to display it in, as well as 
force that language rules for indexes & sorting.  I know how to set 
COLLATION for the sorting / index rules but how would I force the select 
results to be displayed in another language such as French or German?

Thanks in advance




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin