Setting locale per connection

Поиск
Список
Период
Сортировка
От Behdad Esfahbod
Тема Setting locale per connection
Дата
Msg-id Pine.LNX.4.44.0307020717040.20969-200000@gilas.bamdad.org
обсуждение исходный текст
Ответы Re: Setting locale per connection  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: Setting locale per connection  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Hi all,

I'm new to the list, so don't flame at the first date ;).

I usually use PostgreSQL for multiple languages, so I needed to
set locale per connection, or can change the locale on the fly.  
I don't know if there is any such ability integrated in or not,
so I have wrote my 10lines function as a wrapper around
setlocale, that is attached.  So what I do is just a simple
"SELECT locale('LC_COLLATE', 'fa_IR');" at connection time. Let
me know if there is any standard way already implemented.

Another silly question, isn't any way to get rid of seqscan, when 
doing 'SELECT count(*) FROM tab;'?

Yours,
behdad

-- 
Behdad Esfahbod        11 Tir 1382, 2003 Jul 2 
http://behdad.org/    [Finger for Geek Code]

If you do a job too well, you'll get stuck with it.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Urgent : Regarding Submission of Code
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: PHP/PgSQL *and* libpq ...