Re: Localization (for dates) Oracle vs. Postgresql

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Localization (for dates) Oracle vs. Postgresql
Дата
Msg-id 87iso9d7zs.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: Localization (for dates) Oracle vs. Postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: darren@crystalballinc.com
Дата:
Сообщение: Re: is it possible to do this? have a subselect that
Следующее
От: Ron
Дата:
Сообщение: Re: is it possible to do this? have a subselect that returns