"Josh Berkus" <[EMAIL PROTECTED]> writes:
> I don't want to go through a bunch of non-ANSI SQL-compliant conversion
> functions to do it. Especially not as this is just what the ANSI SQL
> data type and operator specs are designed to support.
Curiously enough, ANSI doesn't define an INTERVAL-divided-by-INTERVAL
function either. Also, it rather looks like ANSI adopted the position
Peter E. expressed:
Year-month intervals are mutually comparable only with other year-
month intervals. [...]
Day-time intervals are mutually comparable only with other day-
time intervals. [...]
Operations involving items of type datetime require that the date-
time items be mutually comparable. Operations involving items of
type interval require that the interval items be mutually compara-
ble.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
