Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 Jun 2009 08:46:28 -0600
- Message-id: <dcc563d10906300746i19b165e0r2aaa6acafb26b6b4@mail.gmail.com> <text/plain>
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.
- References:
- Prev by Date: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Next by Date: configure PG clients for DNS
- Previous by thread: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Next by thread: Application Transaction Question... Postgres 8.3.6 - PHP 5 - Solaris 10
- Indexes: