> Any thought?
Hmm. It is not consistantly implemented :(
timestamp_part() uses just the fractional part of the seconds to
calculate milliseconds. But interval_part() uses both fractional and
integer parts to figure the result, and that is the routine which ends
up being used for the time value.
I'd assume that it should be using fractional seconds only, just like
timestamp_part() does. Any reason not to change it for 7.1?
btw, what should 'microseconds' return? It suffers from the problems
mentioned already, plus leaves the "milliseconds" part in the result.
That should probably only return the pieces which are less than a
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-01-05 07:16:09|
|Subject: Re: Re: time + date_part oddness? |
|Previous:||From: Tom Lane||Date: 2001-01-05 06:18:47|
|Subject: Well, we seem to be proof against cache-inval problems now|