| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Brendan Jurd <direvus(at)gmail(dot)com>, Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp default values |
| Date: | 2005-08-07 16:30:59 |
| Message-ID: | 20050807163059.GB22043@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poul Møller Hansen | 2005-08-07 19:44:53 | Re: Remopte connection to POstgreSQL via ODBC |
| Previous Message | Zlatko Matić | 2005-08-07 15:42:41 | Remopte connection to POstgreSQL via ODBC |