Re: BUG?: timestamp without TZ created as timestamp - Mailing list pgsql-general

From Thomas O'Dowd
Subject Re: BUG?: timestamp without TZ created as timestamp
Date
Msg-id 1030632717.7732.43.camel@beast.uwillsee.com
Whole thread Raw
In response to Re: BUG?: timestamp without TZ created as timestamp *with* TZ  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG?: timestamp without TZ created as timestamp *with* TZ  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi Tom,

On Thu, 2002-08-29 at 22:56, Tom Lane wrote:
> That is the behavior in 7.2; it's a transient state to help people
> migrate from our old not-very-SQL-compliant datatype names.
>
> In 7.3 "timestamp" will mean "timestamp without time zone" per spec.

Just looking at the 7.3 docs... Is this right? Have the docs been
updated yet?

http://developer.postgresql.org/docs/postgres/datatype-datetime.html

timestamp [ (p) ] without time zone
timestamp [ (p) ] [ with time zone ]

which implies to me that "timestamp" means "timestamp with time zone"???

Its also quite late here and I'm a bit star-eye'd so maybe I've got it
all wrong.

Thanks,

Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs


pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: Compiling 7.2.1 with JDBC-Support fails - help needed
Next
From: Gregory Seidman
Date:
Subject: Re: Compiling 7.2.1 with JDBC-Support fails - help needed