Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...

Greg Stark <gsstark@mit.edu> writes:
> I just don't see what use a timestamp that doesn't represent a particular time
> would ever be. It seems to serve only as a gotcha for unwary programmers who
> take the default.

I have a problem with that too :-( ... timestamptz seems much the more
generally useful type.  But the SQL spec is pretty definite that
"timestamp" means "timestamp without time zone".

Is anybody interested in the idea of a GUC parameter to choose whether
"timestamp" means "timestamp with time zone" (useful) or "timestamp
without time zone" (anally spec-compliant)?  Or would that just muddy
the waters even more than they are already?  We already changed the
meaning once...

            regards, tom lane