Postgres Pro
Downloads
Home   >   mailing lists

Thread: timezone default

timezone default

From
Josh Purinton
Date:
According to
<http://www.postgresql.org/docs/current/static/datatype.html>,
'timestamp' defaults to 'timestamp with time zone'. But that page also
lists 'timestamp' an alias for 'timestamp without time zone'.

Something's not right.

--
Josh Purinton

Re: timezone default

From
Tom Lane
Date:
Josh Purinton <joshp-scod-lqsgp.z.jp@xoxy.net> writes:
> According to
> <http://www.postgresql.org/docs/current/static/datatype.html>,
> 'timestamp' defaults to 'timestamp with time zone'. But that page also
> lists 'timestamp' an alias for 'timestamp without time zone'.

Good catch.  Table 8-9 has the brackets in the right places, but it
looks like we missed updating table 8-1.

            regards, tom lane