to_char() and negative intervals - Mailing list pgsql-hackers

From Bruce Momjian
Subject to_char() and negative intervals
Date
Msg-id 200408131402.i7DE2Z817167@candle.pha.pa.us
Whole thread Raw
Responses Re: to_char() and negative intervals  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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                        |  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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trigger function returning null
Next
From: Gaetano Mendola
Date:
Subject: hot spare / log shipping work on