Postgres Pro
Downloads
Home   >   mailing lists

Re: Timestamp Datatype Changing automatically to Timestamp without time zone - Mailing list pgsql-admin

From Tom Lane
Subject Re: Timestamp Datatype Changing automatically to Timestamp without time zone
Date
Msg-id 17585.1246373120@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timestamp Datatype Changing automatically to Timestamp without time zone  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Timestamp Datatype Changing automatically to Timestamp without time zone  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view 
Scott Marlowe <scott.marlowe@gmail.com> writes:
> If I remember correctly, the sql standard says that timestamp, alone,
> means timestamp without timezone.  But prior to 8.1 pgsql implemented
> timestamp as timestamp with timezone.

No, you're thinking of a change that happened in 7.3.

            regards, tom lane

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
Next
From: Scott Marlowe
Date:
Subject: Re: Timestamp Datatype Changing automatically to Timestamp without time zone