"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