Re: timestamps-accuracy

[Martijn van Oosterhout <kleptog(at)svana(dot)org>]

On Fri, May 09, 2008 at 04:59:30AM -0400, Justin wrote:
> 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? 

I would suggest storing it as epoch time (seconds since X) in a numeric
fields and create some helper functions to get data in and out in the
right format. Or a timestamp(0) column with an additional nano-second
column.

Depending on how often you use it it may be interesting to create a
specific type, but this may come close enough.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

Attachment: signature.asc
Description: Digital signature