> select '1 5 hours'::interval = '1 day 5 hours'::interval;
> (1 row)
> I think that the first spelling, a unit-less '1', should not be accepted.
Not sure I agree. The syntax '1 05:00' is required by spec to mean
'1 day 5 hours 0 minutes'. I would take that to mean that a unitless
number directly to the left of an hours field is days. Anyway, the
code in DecodeInterval is treating these cases the same.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2012-08-16 00:31:07|
|Subject: Re: [BUGS] documentation bug - behave of NEW a OLD in plpgsql's
|Previous:||From: Tom Lane||Date: 2012-08-15 23:18:03|
|Subject: Re: Possible Bug in 9.2beta3|