Shruthi A <shruthi.iisc@gmail.com> writes:
> The page http://www.postgresql.org/docs/7.2/static/datatype-datetime.htmlmentions
> that the resolution of all time and timestamp data types is 1
> microsecond. I have an application that runs on both a Windows (XP with
> SP2) machine and a Linux (SUSE 10.2) machine. I saw that on postgres
> enterprisedb 8.3 installed on both these machines, the default timestamp
> precision on the former is upto a millisecond and on the latter it is 1
> microsecond.
I suppose what you're really asking about is not the precision of the
datatype but the precision of now() readings. You're out of luck ---
Windows just doesn't expose a call to get the wall clock time to better
than 1 msec.
Keep in mind that whatever the Linux machine is returning might be
largely fantasy in the low-order bits, too.
regards, tom lane