Re: int4 -> unix timestamp -> sql timestamp; abstime?

Roman Neuhauser <neuhauser@chello.cz> writes:
>> The recommended locution is
>>
>> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';

>     Have I missed this in the manual?

The 8.0 docs mention this in the discussion of extract(epoch), but I'm
not sure if it was there before.  It's been discussed in the mailing
list archives many times...

            regards, tom lane