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@svana.org]
> Sent:    woensdag 12 juni 2002 10:23
> To:    Ken Williams
> Cc:    pgsql-general@postgresql.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@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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html