Re: Transparent i18n? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Transparent i18n?
Date
Msg-id 20050702110831.A568@hermes.hilbert.loc
Whole thread Raw
In response to Re: Transparent i18n?  (David Pratt <fairwinds@eastlink.ca>)
Responses Re: Transparent i18n?
List pgsql-general
> SELECT language_text[1][1] AS language_code,
>  language[1][2] AS text
> FROM language_text;

They way we do that in GNUmed:

 select lookup_val, _(lookup_val) from lookup_table where ...;

If you want to know how see here:


http://savannah.gnu.org/cgi-bin/viewcvs/gnumed/gnumed/gnumed/server/sql/gmI18N.sql?rev=1.20&content-type=text/vnd.viewcvs-markup

Feel free to ask for clarification.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: "Ramapriya N"
Date:
Subject: returning multiple records - URGENT
Next
From: "Alejandro D. Burne"
Date:
Subject: wrong sort order