Re: Timestamp Datatype Changing automatically to Timestamp without time zone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Rajdeep Das <sendrajster(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
Date: 2009-06-30 14:45:20
Message-ID: 17585.1246373120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-06-30 14:46:28 Re: Timestamp Datatype Changing automatically to Timestamp without time zone
Previous Message Scott Marlowe 2009-06-30 14:40:43 Re: Timestamp Datatype Changing automatically to Timestamp without time zone