to_char (was Re: fomatting an interval)

Поиск
Список
Период
Сортировка
От elein
Тема to_char (was Re: fomatting an interval)
Дата
Msg-id 200305291922.04980.elein@varlena.com
обсуждение исходный текст
Ответ на Re: fomatting an interval  (Karel Zak <zakkr@zf.jcu.cz>)
Ответы Re: to_char (was Re: fomatting an interval)  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-general

I'm sorry I am not up on hackers' discussions on this.

What is to be the alternative to to_char()?
I use to_char very heavily for pretty output of dates and times.
And I know I'm not the only one.

Will there be separate from interval, from timestamp, etc. functions?
Extract is not adequate because then you have to concatenate
it all back together again.  It is important to have the formatting
simple and in one function if possible.  A lot of notice needs
to be put out before  deprecating to_char since it is really
widely used.

(The 7.3.3. bug is unfortunate.  But I don't think it is a trigger
to dump the whole function.)

elein


On Wednesday 28 May 2003 03:24, Karel Zak wrote:
> On Mon, May 12, 2003 at 09:09:20PM -0400, Tom Lane wrote:
> > >>> How can I format an interval?
> >
> > Well, there are several possibilities such as to_char() and EXTRACT()
> > ...
>
>  I think we will mark to_char(interval) as deprecated function and
>  it will removed in some next release. It was already discussed.
>
>     Karel
>
> --
>  Karel Zak  <zakkr@zf.jcu.cz>
>  http://home.zf.jcu.cz/~zakkr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>

--
=============================================================
elein@varlena.com     Database Consulting     www.varlena.com
PostgreSQL General Bits    http:/www.varlena.com/GeneralBits/
   "Free your mind the rest will follow" -- en vogue


В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Join question
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Join question