Re: to_char() and negative intervals

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-08-16T14:43:10Z
Lists: pgsql-hackers
Karel Zak wrote:
> On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Someone on IRC just reported this to_char() failure with negative
> > > intervals:
> > 
> > I think Karel wanted to remove to_char(interval) altogether.
> 
>  Yes, the notice about it is already in 7.4 docs. Maybe we can remove
>  it in 7.5/8.0. Comments?

I don't see how we can remove it in 8.0 unless we require an initdb. 
What we could do is to throw an error/warning in the code and remove it
completely in 8.1.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073