Re: Localization (for dates) Oracle vs. Postgresql

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> "Amin Schoeib" <aschoeib(at)4tek(dot)de> writes:
> > Is there maybe any other???
>
> The only other suggestion I can make is to write your own formatting
> function. It'd be a pain in the neck to build a general-purpose one,
> but you could handle a fixed output format with just a few lines of code
> in plpgsql. (Might be even easier in plperl or pltcl.) That would
> probably tide you over until to_char() has more locale support.

I was planning on doing a date formatting function that took an extra locale
parameter like my xfrm function. But I haven't gotten there yet. I have to
read up on strftime before I start too. I'm not clear how to handle the fact
that different locales prefer different orders for their fields.

--
greg