Re: Timestamp with time zone: why not? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Timestamp with time zone: why not?
Date
Msg-id 46551E48.6080206@cox.net
Whole thread Raw
In response to Timestamp with time zone: why not?  (km@acrasis.net)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/23/07 18:54, km@acrasis.net wrote:
> Would I be right in thinking that, in general, a column to hold
> timestamp values is best created with type 'TIMESTAMP WITH TIME ZONE'
> and not 'TIMESTAMP' nor 'TIMESTAMP WITHOUT TIME ZONE'?
>
> To put it another way, for what reasons might the 'TIMESTAMP' type be
> preferred to 'TIMESTAMP WITH TIME ZONE'?

Importing data from a legacy system that doesn't "do" timezones.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGVR5HS9HxQb37XmcRAilwAJ9JSQEWDNdRUePIP+wXlHBEN0sG8gCg50K5
ccYj7+WkwdL7CkfoOgDEHDs=
=h+pn
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Next
From: Tom Lane
Date:
Subject: Re: Integrity on large sites