dan...@heroku.com writes: > select '1 5 hours'::interval = '1 day 5 hours'::interval; > ?column? > ---------- > t > (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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs