Going through the standard I don't see a reference as to what the behavior for multiplication against time is. What PG is doing is giving you back min:sec, what we are doing is giving you back the actual number of seconds.
We are returning the result as a REAL though, and it is an open question as to what should be returned (or if what a user should expect is an error).
Going through the standard I don't see a reference as to what the behavior for multiplication against time is. What PG is doing is giving you back min:sec, what we are doing is giving you back the actual number of seconds.
We are returning the result as a REAL though, and it is an open question as to what should be returned (or if what a user should expect is an error).