Re: automatic time zone conversion - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: automatic time zone conversion
Date
Msg-id 20020612182321.A9443@svana.org
Whole thread Raw
In response to Re: automatic time zone conversion  (Ken Williams <ken@mathforum.org>)
Responses Re: automatic time zone conversion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 12, 2002 at 05:12:56PM +1000, Ken Williams wrote:
> Yeah, but watch this:
>
> ==============================================================
> announce=# create table test (x timestamp without time zone);
> CREATE
> announce=# \d test
>                    Table "test"
>   Attribute |           Type           | Modifier
> -----------+--------------------------+----------
>   x         | timestamp with time zone |
>
> ==============================================================

Ouch! What version is that? Here I get:

===========================================================
kleptog=# create table test2 (x timestamp without time zone);
CREATE
kleptog=# \d test2
                  Table "test2"
 Column |            Type             | Modifiers
--------+-----------------------------+-----------
 x      | timestamp without time zone |

kleptog=# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)

===========================================================

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

pgsql-general by date:

Previous
From: Ken Williams
Date:
Subject: Re: automatic time zone conversion
Next
From: "Bertin, Philippe"
Date:
Subject: Re: automatic time zone conversion