Re: [SQL] now() with microsecond granulity needed

[Tom Lane]

Radoslaw Stachowiak <[EMAIL PROTECTED]> 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