The year to month and day to second intervals should not overlap. The standard doesn't actually allow it IIRC.
wt On Jan 9, 2008 7:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Ilya A. Kovalenko" <[EMAIL PROTECTED]> writes: > > I suggest one more standard date/time operator, to divide one interval > > by another with numeric (or float, for example) result. > > You'd have to define exactly what that means, which seems a little > tricky for incommensurate intervals. For instance what is the > result of '1 month' / '1 day' ? > > regards, tom lane > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
