Alessio Bragadini <alessio(at)albourne(dot)com> writes:
> starting with 7.2, now() returns a time with milliseconds. If extracted
> from the db and displayed verbatim, it shows up as
> '2002-02-05 10:59:36.717176+02'.
Use to_char if you want to control the formatting precisely. Or
replace now() with CURRENT_TIMESTAMP(0) (which not only does what
you want, but is standards-compliant).
regards, tom lane