Re: timestamp with definable accuracy, was: Re: empty text - Mailing list pgsql-general

From Alban Hertroys
Subject Re: timestamp with definable accuracy, was: Re: empty text
Date
Msg-id 44B36B9D.1000504@magproductions.nl
Whole thread Raw
In response to timestamp with definable accuracy, was: Re: empty text fields  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
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@magproductions.nl

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 //

pgsql-general by date:

Previous
From: "Leif B. Kristensen"
Date:
Subject: Re: Problem with COPY
Next
From: "Christian Rengstl"
Date:
Subject: Getting progress of operation