Re: time + date_part oddness?
От | Thomas Lockhart |
---|---|
Тема | Re: time + date_part oddness? |
Дата | |
Msg-id | 3A556E80.F18AE49B@fourpalms.org обсуждение исходный текст |
Ответ на | time + date_part oddness? (Tatsuo Ishii <t-ishii@sra.co.jp>) |
Ответы |
Re: Re: time + date_part oddness?
|
Список | pgsql-hackers |
> 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 millisecond... - Thomas
В списке pgsql-hackers по дате отправления: