Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Date: 2003-02-18 00:43:27
Message-ID: 87el66fmfk.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Sean Chittenden <sean(at)chittenden(dot)org> writes:
>
> Also, although the on-disk format of the two types might be the same,
> that doesn't mean they have the same interpretation of a given byte
> value. They don't (unless you run your database with TimeZone = GMT).

This is a point I'm unclear on as well, the documentation is very confusing.

The documentation I've read makes it sound like these two data types are
equivalent in every way except for the default timezone assumed interpretation
when converting to and from textual representations. Is that not true?

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-02-18 01:26:45 Re: Index not used with IS NULL
Previous Message Tom Lane 2003-02-17 23:29:34 Re: pg_dump --> restore loses constraints/triggers?