Re: Localization (for dates) Oracle vs. Postgresql

Tom Lane <tgl@sss.pgh.pa.us> writes:

> "Amin Schoeib" <aschoeib@4tek.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