Re: timestamp default values - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: timestamp default values
Date
Msg-id 20050807163059.GB22043@alvh.no-ip.org
Whole thread Raw
In response to Re: timestamp default values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sun, Aug 07, 2005 at 12:47:19AM -0400, Tom Lane wrote:

> BTW: at least with our current interpretation of these datatypes, the
> only type that is sensible for a now()-like function to return is
> timestamptz.  Not plain timestamp; that cannot be considered to
> represent a well-defined instant at all.

BTW, do we have a type which stores the TZ it originally had?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"No hay hombre que no aspire a la plenitud, es decir,
la suma de experiencias de que un hombre es capaz"

pgsql-general by date:

Previous
From: Zlatko Matić
Date:
Subject: Remopte connection to POstgreSQL via ODBC
Next
From: Poul Møller Hansen
Date:
Subject: Re: Remopte connection to POstgreSQL via ODBC