Re: Timestamp Datatype Changing automatically to Timestamp without time zone

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:46:28
Message-ID: dcc563d10906300746i19b165e0r2aaa6acafb26b6b4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jun 30, 2009 at 8:45 AM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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.

Ahh, ok. I knew I'd lived through it, but it was just longer ago than
I thought.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Martinez 2009-06-30 15:03:47 Re: configure PG clients for DNS
Previous Message Tom Lane 2009-06-30 14:45:20 Re: Timestamp Datatype Changing automatically to Timestamp without time zone