timestamps-accuracy

From: Justin <justin(at)emproshunts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: timestamps-accuracy
Date: 2008-05-09 08:59:30
Message-ID: 48241272.8080109@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We noticed that several records which have a time stamp column have
the same time stamp which i can understand given the time stamps have 1
microsecond resolution.

generail this don't hurt us but we have some needs with data coming from
manufacturing testing applications that needs to keep the timestamps to
.000,000,001 aka 1 nano second.
what would be the easiest way to do this?

Just as mind numbing we actual measure electrical resistance out that
far to and have to keep track of it in the database.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-05-09 09:16:13 Re: timestamps-accuracy
Previous Message Christian.Strobl 2008-05-09 08:31:48 reproducible database crash with simple sql command on postgres 8.3.1