Search Postgresql Archives

Re: timestamp with definable accuracy, was: Re: empty text

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Karsten Hilbert wrote:
Just for your information:

In our Python implementation of a fuzzy timestamp type we
used accuracy values ranging from 1 to 7 denoting the
"precision" of a complete timestamp definition:

7 - full subsecond accuracy (7 "digits" precision)
6 - seconds
5 - minutes
4 - hours
3 - days
2 - months
1 - years

This is getting off topic, but let me add that IMO you chose the wrong direction. Your timestamps won't get any more accurate than seconds (your highest value), but it could get less accurate. What are you going to use for ranges larger than a year? 0? -1? -2? You locked yourself out...

--
Alban Hertroys
alban@xxxxxxxxxxxxxxxxx

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux