Re: New timezones used in regression tests

On Tue, May 13, 2014 at 09:55:26AM -0400, Alvaro Herrera wrote:
> Christoph Berg wrote:
>
> > Of course, Wikipedia has something to say about this:
> > http://en.wikipedia.org/wiki/Timekeeping_on_Mars
>
> Nice.
>
> > I especially like MTC, Mars Time Coordinated. But whatever scheme gets
> > chosen, it won't be a standard 24h day, so PostgreSQL has a whole lot
> > of different problems to solve than to "fix" that little
> > Mars/Mons_Olympus gem now... :)
>
> Maybe a new type, mars_timestamptz()? Or perhaps the celestial body
> name should be part of the typmod for standard timestamptz ...?

The latter seems a good bit more extensible.

Conversions among the different timestamptzs might be problematic, as
we are currently assuming certain approximations about spacetime that
don't actually hold when we have time zones in significantly different
reference frames.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate