Skip site navigation (1) Skip section navigation (2)

Re: Undocumented datetime functions

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-docs(at)postgresql(dot)org, Thomas Lockhart <lockhart(at)fourpalms(dot)org>
Subject: Re: Undocumented datetime functions
Date: 2001-02-17 23:29:08
Message-ID: 3A8F0944.30DE0665@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-docs
> > Hmm, I'm confused.  The timestamp type doesn't actually have a time zone
> > stored, does it?  Why did you want it to be dumped as "timestamp with time
> > zone" then?

Because it has "time zone aware behavior". And the input carries time
zone information, either implicitly or explicitly. And the output
carries time zone information. But...

> Andreas pointed that out awhile ago.  I'm inclined to agree: equating
> timestamp to timestamp with time zone is dead wrong, and we should
> revert that pg_dump change.

This issue is not as black and white as you seem to think. As you
probably know, the SQL9x definitions for date/time types are
fundamentally flawed, with no possibility for awareness of DST, local
time, etc etc. Cf Date and Darwen for a discussion of other aspects of
the problems. I don't really care whether what we currently have is
"timestamp" or "timestamp with time zone", but if, for example, I/we
implement an SQL9x-conforming "timestamp with time zone" it will not get
used. So where do we want our current data type to fit in, and how do we
want to "fill in the edges" of our feature set? An enlightened
discussion would be helpful here, though since we are not in a position
to discuss fundamental changes at the moment perhaps limiting it to
"which side of the fence?" for the existing timestamp implementation
would be sufficient.

                     - Thomas

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2001-02-17 23:47:15
Subject: Re: Undocumented datetime functions
Previous:From: Jose Felix OntaƱon CarmonaDate: 2001-02-17 19:04:52
Subject: a little question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group