Setting of locales at runtime ?

From: David Sauer <davids(at)penguin(dot)cz>
To: pgsql-general(at)hub(dot)org
Subject: Setting of locales at runtime ?
Date: 1999-12-09 15:25:46
Message-ID: m2zovkf85h.fsf@chameleon.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have question about postgres: it is possible (or planned) to change
locales (and sorting) at runtime ? For example, I will have 2 tables, in 2
different languages. I want following:

set locale cs;
select * from table1 order by 1; // this will sort by first column
// and use czech locale

set locale es;
select * from table2 order by 2; // this will sort using spanish locale

thanks,

David

--
* David Sauer, student of Czech Technical University
* electronic mail: davids(at)penguin(dot)cz (mime compatible)

Browse pgsql-general by date

  From Date Subject
Next Message admin 1999-12-09 16:13:26 using limit instead of seeking
Previous Message Nikolay Mijaylov 1999-12-09 14:35:35 Re: [GENERAL] get the previous assigned sequence value