Re: [HACKERS] to_char() and negative intervals

2004-08-17 Thread Bruce Momjian
We will either remove it in 8.0 or mention its removal in 8.1. It is probably wisest to remove in 8.1. --- Bruce Momjian wrote: > > Added to open items: > > * remove to_char(interval) if we initdb > > > --

Re: [HACKERS] to_char() and negative intervals

2004-08-16 Thread Bruce Momjian
Added to open items: * remove to_char(interval) if we initdb --- Alvaro Herrera wrote: > On Mon, Aug 16, 2004 at 10:43:10AM -0400, Bruce Momjian wrote: > > Karel Zak wrote: > > > On Fri, Aug 13, 2004 at 12:24:28PM

Re: [HACKERS] to_char() and negative intervals

2004-08-16 Thread Alvaro Herrera
On Mon, Aug 16, 2004 at 10:43:10AM -0400, Bruce Momjian wrote: > Karel Zak wrote: > > On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > Someone on IRC just reported this to_char() failure with negative > > > > intervals: > > > > > > I

Re: [HACKERS] to_char() and negative intervals

2004-08-16 Thread Bruce Momjian
Karel Zak wrote: > On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> 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 no

Re: [HACKERS] to_char() and negative intervals

2004-08-16 Thread Karel Zak
On Fri, Aug 13, 2004 at 12:24:28PM -0400, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 d

Re: [HACKERS] to_char() and negative intervals

2004-08-13 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Someone on IRC just reported this to_char() failure with negative > intervals: I think Karel wanted to remove to_char(interval) altogether. regards, tom lane ---(end of broadcast)-

[HACKERS] to_char() and negative intervals

2004-08-13 Thread Bruce Momjian
Someone on IRC just reported this to_char() failure with negative intervals: test=> SELECT to_char('-00:17:56.886375'::interval, 'HH24:MI:SS'); to_char -- 00:-1:-5 (1 row) Looks like a bug to me. :-) -- Bruce Momjian