Re: Revisiting extract(epoch from timestamp)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Revisiting extract(epoch from timestamp)
Дата
Msg-id 10732.1333995204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Revisiting extract(epoch from timestamp)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
>> so that we could mark it immutable.  On the other hand, it's not
>> entirely apparent why people would need to create indexes on the epoch
>> value rather than just indexing the timestamp itself

> Well, it makes for smaller indexes if you don't really care about 
> sub-second resolutions.

Well, maybe in principle, but in practice it's an 8-byte value either
way.  I guess you could down-convert to an int4 if you plan to be
safely dead before 2038 ...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Atri Sharma
Дата:
Сообщение: Re: [JDBC] Regarding GSoc Application
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Regarding column reordering project for GSoc 2012