Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes: > Given that all of our dates will fall within what we can store in 4bytes, > what would be the easiest way to use epoch as a timestamp? Well, if you're bound and determined to create a Y2038 problem for yourself, you could use the legacy "abstime" datatype. Actually, that choice will blow up on you rather sooner than 2038, since I'm sure we'll pull abstime from the system well before it actually starts failing to represent now(). But future-proofing doesn't seem to be part of your design goals, so you might as well use it while it's there. regards, tom lane
