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 el
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
Oleg Bartunov 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 really need i
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 this
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 (
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 im
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/
sql/gmI18N.sql?rev=1
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.20&content-type=text/vnd.viewcvs-markup
> Many thanks Karsten for some insight into how you are handling this.
David,
if you go to the Developer
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
multi_language
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, _(l
> 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/sq
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
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
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 seemed
14 matches
Mail list logo
