Re: Precision of data types and functions

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Brandon Aiken <BAiken(at)winemantech(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Precision of data types and functions
Date: 2006-09-01 21:01:20
Message-ID: 1157144479.4786.38.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2006-09-01 at 13:33, Brandon Aiken wrote:
> Of course the year exists. The date itself is nonsensical, however.
>
> 'January 3, 648' does reference a valid day, but the date itself has no
> meaning at that time in the world, so there is very little meaning in
> using Gregorian dates except to give us a relativistic idea of when it
> occurred. Nevertheless, you can never say with specificity anything
> that occurred on any given date prior to the inception of the Gregorian
> calendar without doing conversions to a calendar no longer in use while
> taking into account the numerous error corrections that have been made
> to various calendars. Knowing the year and season something happened is
> about the best that can be expected.

Actually, it's far worse than that. I was reading up on the adoption
rate of the gregorian calendar, and because of delays in its adoption by
various folks over the centuries since it was invented (and the fact
that some religions STILL don't recognize it) there are many dates that
are recorded differently throughout history since it was created.

I read up a bit on it at http://en.wikipedia.org/wiki/Gregorian_calendar
and it's enough to make your head spin... The trivia section near the
bottom is particularly interesting.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message zxo102 2006-09-02 01:31:15 how to integrate postgresql into my installer in Window system?
Previous Message Randall Lucas 2006-09-01 20:36:51 Re: Dependency graph of all tuples relied upon in a query answer