Tilo Schwarz <[EMAIL PROTECTED]> writes:
> while trying to create a query this afternoon dealing with intervals, I
> noticed the following behaviour and I wondered, if it is intended.
> tschwarz=> select '-1'::interval;
> interval
> ----------
> -01:00 <---
> (1 row)
This appears to be intentional --- the comment in DecodeInterval says
/*
* Only a signed integer? Then must assume a
* timezone-like usage
*/
type = DTK_HOUR;
whereas nearby code selects DTK_SECOND scaling for the cases of
fractional or unsigned numbers. I'm not sure *why* it's intentional,
and am hesitant to change it without knowing what the rationale was.
There may be cases involving multiple fields that need the existing
behavior...
> tschwarz=> select '-0.1'::interval;
> interval
> -------------
> 00:00:00.10 <---
> (1 row)
This is incontestably a bug. Will fix for 7.4.1.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
