Re: timestamp resolution?
| От | Thomas Lockhart |
|---|---|
| Тема | Re: timestamp resolution? |
| Дата | |
| Msg-id | 3BBCA07E.676AAE07@fourpalms.org обсуждение исходный текст |
| Ответ на | timestamp resolution? (Tatsuo Ishii <t-ishii@sra.co.jp>) |
| Ответы |
Re: timestamp resolution?
|
| Список | pgsql-hackers |
...
> Ah, I've got it. Two problems: AdjustTimestampForTypmod is one brick
> shy of a load, and the hardwired calls to timestamp_in and friends
> weren't passing all the parameters they should. (Can anyone think of
> a way for DirectFunctionCall to do any checking?)
OK, I found the second item last night, but am not sure why
AdjustTimestampForTypmod needs more fixes.
I'm going through gram.y and fixing up the implementations of
CURRENT_TIMESTAMP et al. One point folks will run into is that
CURRENT_TIMESTAMP *should* return time to the second, not fractions
thereof, and CURRENT_TIMESTAMP(p) should be used to get something more
precise. Another issue I just noticed is that the result of
create table t1 (d timestamp(2) default current_timestamp);
gives me two decimal points of fractional seconds (after fixups for
Tatsuo's reported troubles) but I would think that it should round to
the second. Looks like we are "type folding" past the typmod attributes.
Comments?
- Thomas
В списке pgsql-hackers по дате отправления: