Richard Huxton <dev@archonet.com> writes:
> In. Martin Pr��ek wrote:
>> I I read the documentation well (PG 7.3.3 ) , i see that there is not a native support for data type UNIX
TIMESTAMPand "unix timestamp expressed as microseconds"
>>
>> ie there it is impossible to direct insert and select
>>
>> seconds_from _Epoch
>> seconds_from _Epoch (period) microseconds_part
>> seconds_from _Epochmicroseconds_part
>>
>> without some data conversion ?
> You could use a numeric type if that's what you want -
I'd stick with the basic float representation of timestamps. We don't
have the particular syntaxes suggested above, but the functionality is
all there, eg
regression=# select extract(epoch from now());
date_part
------------------
1085153447.89091
(1 row)
regards, tom lane