Re: automatic time zone conversion

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.