>>>>> "Radoslaw" == Radoslaw Stachowiak <[EMAIL PROTECTED]> writes:
Radoslaw> *** Tom Lane <[EMAIL PROTECTED]> [Tuesday,
Radoslaw> 20.February.2001, 11:57 -0500]:
>> > using now() to init TIMESTAMP fields I got resolution of one
>> second. How > can I define DEFAULT in column (TIMESTAMP type)
>> to get higher > time-resolution (TIMESTAMP supports
>> microseconds).
>>
>> You could make a variant of now() that relies on gettimeofday()
>> instead of time(). Note that you probably won't get
>> microsecond precision in any case...
Radoslaw> Do You mean changing sources and recompiling? So there
Radoslaw> is no way of getting more accurate NOW time directly in
Radoslaw> SQL ? /DEFAULT clause/ at this moment?
the timeofday function seems to work:
acspg=# select timeofday();
timeofday
-------------------------------------
Wed Feb 21 15:56:43.150389 2001 EST
(1 row)
acspg=#
