to_char (was Re: fomatting an interval)

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(at)zf(dot)jcu(dot)cz>
> http://home.zf.jcu.cz/~zakkr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>

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