Mars G Miro <mars@cannoncreek.com> writes:
> how do I make it accurate up to milliseconds value?
You don't. current_timestamp depends on the time() system call,
which only returns a number accurate to one second.
There is a higher-precision current time function in 7.1, but I
forget the details ... see the docs. IIRC it existed but was
buggy in 7.0, so you'll need to update.
regards, tom lane