Radoslaw Stachowiak <radek(at)alter(dot)pl> writes:
> 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...
regards, tom lane