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(at)svana(dot)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.