to_char (was Re: fomatting an interval) - Mailing list pgsql-general

From elein
Subject to_char (was Re: fomatting an interval)
Date
Msg-id 200305291922.04980.elein@varlena.com
Whole thread Raw
In response to Re: fomatting an interval  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: to_char (was Re: fomatting an interval)  (Karel Zak <zakkr@zf.jcu.cz>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Join question
Next
From: Bruno Wolff III
Date:
Subject: Re: Join question