Re: Localization (for dates) Oracle vs. Postgresql - Mailing list pgsql-general

From Greg Stark
Subject Re: Localization (for dates) Oracle vs. Postgresql
Date
Msg-id 87iso9d7zs.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Localization (for dates) Oracle vs. Postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: darren@crystalballinc.com
Date:
Subject: Re: is it possible to do this? have a subselect that
Next
From: Ron
Date:
Subject: Re: is it possible to do this? have a subselect that returns