Re: automatic time zone conversion

Some Unix setting influencing these results ? Or some PostgreSQL-
configuration setting that's disabled/enabled ? In postgresql.conf I could
only see something like australian_timezones (commented out). No clue what
that could possibly do.

> -----Original Message-----
> From: Martijn van Oosterhout [SMTP:kleptog(at)svana(dot)org]
> Sent: woensdag 12 juni 2002 10:23
> To: Ken Williams
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html