Setting locale per connection - Mailing list pgsql-hackers

From Behdad Esfahbod
Subject Setting locale per connection
Date
Msg-id Pine.LNX.4.44.0307020717040.20969-200000@gilas.bamdad.org
Whole thread Raw
Responses Re: Setting locale per connection  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: Setting locale per connection  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Urgent : Regarding Submission of Code
Next
From: "Marc G. Fournier"
Date:
Subject: Re: PHP/PgSQL *and* libpq ...