On Mon, Jul 04, 2005 at 03:27:59PM -0300, David Pratt wrote:
I am also going to look at Karsten's material shortly to see how his system
works
I am still away from the net but here is how to find the
description in our Wiki:
Go to user support, user guide, scroll down do developers
guide, go
Many thanks Karsten. I got a system working with arrays yesterday but
will still be examining your code. I guess the next challenge is to see
how well the multidimensional array can be searched. I guess I could
make indexes on an expression to retrieve language for a specific key
since each
On Sat, Jul 02, 2005 at 05:00:50PM -0300, David Pratt wrote:
http://savannah.gnu.org/cgi-bin/viewcvs/gnumed/gnumed/gnumed/server/sql/gmI18N.sql?rev=1.20content-type=text/vnd.viewcvs-markup
Many thanks Karsten for some insight into how you are handling this.
David,
if you go to the Developers
Many thanks, Karsten. I am going to look at your example closely.
Regards
David
On Sunday, July 3, 2005, at 09:50 AM, Karsten Hilbert wrote:
On Sat, Jul 02, 2005 at 05:00:50PM -0300, David Pratt wrote:
http://savannah.gnu.org/cgi-bin/viewcvs/gnumed/gnumed/gnumed/server/
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
Hi Greg. Not sure about this one since I have never made my own type.
Do you mean like an ip to country type of situation to guess locale?
If so, I am using a ip to country table to lookup ip from request and
get the country so language can be passed automatically to display
proper language
Hi there,
sorry if just misunderstanding but we have contrib/hstore available from
http://www.sai.msu.su/~megera/postgres/gist/
which could be used for storing as many languages as you need.
It's sort of perl hash.
Oleg
On Mon, 4 Jul 2005, David Pratt wrote:
Hi Greg. Not sure about
Oleg Bartunov oleg@sai.msu.su writes:
Hi there,
sorry if just misunderstanding but we have contrib/hstore available from
http://www.sai.msu.su/~megera/postgres/gist/
which could be used for storing as many languages as you need.
It's sort of perl hash.
Huh. That's pretty neat. I don't
David Pratt [EMAIL PROTECTED] writes:
It was suggested that I look at an array.
I think that was me. I tried not to say there's only one way to do it. Only
that I chose to go this way and I think it has worked a lot better for me.
Having the text right there in the column saves a *lot* of
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:
Many thanks Karsten for some insight into how you are handling this.
Regards,
David
On Saturday, July 2, 2005, at 06:08 AM, Karsten Hilbert wrote:
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,
Hi Greg. Well I'm kind of half way but I think what I am doing could
work out.
I have an iso_languages table, a languages table for languages used
and a multi_language table
for storing values of my text fields. I choose my language from
iso_languages. Any table that needs a
I've recently been trying to implement some i18n functionality as simply as
possible into my application. I have a lot of lookup values and such in the
DB that need to be translated, and I would rather not do it in the calling
client.
A friend and I put our heads together, and came up which
Hi Steve. I have been a bit puzzling over a similar issue - not i18
for interface but for text data and trying to sort out a solution so I
will be interested to hear additional advice as well. When I wrote to
the list a couple of weeks back (look for my posting around the 17th) I
was looking
14 matches
Mail list logo