Re: [ADMIN] Timestamp precision in Windows and Linux

2009-12-28 Thread Tom Lane
Shruthi A 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 s

[ADMIN] Timestamp precision in Windows and Linux

2009-12-27 Thread Shruthi A
Hi, 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 ente