Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice... - Mailing list pgsql-general

From Tom Lane
Subject Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Date
Msg-id 9000.1045636466@sss.pgh.pa.us
Whole thread Raw
In response to Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...  (Greg Stark <gsstark@mit.edu>)
Responses Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Childs
Date:
Subject: Re: 7.3.1 takes long time to vacuum table?
Next
From: "Colin Mangiagalli"
Date:
Subject: Re: Transaction Logs Recycling Problem