Re: pgsql: Revert removal of pre-7.4 documenation behavior mentions.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thom Brown <thombrown(at)gmail(dot)com>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Revert removal of pre-7.4 documenation behavior mentions.
Date: 2010-02-24 17:07:23
Message-ID: 201002241707.o1OH7N606870@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Tom Lane wrote:
> Thom Brown <thombrown(at)gmail(dot)com> writes:
> > On 24 February 2010 15:54, Bruce Momjian <momjian(at)postgresql(dot)org> wrote:
> > + Prior to <productname>PostgreSQL</productname> 7.3, writing just
> > + <type>timestamp</type> was equivalent to <type>timestamp with
> > + time zone</type>. This was changed for SQL compliance.
>
> > You may wish to say what exactly it was changed to.
>
> The previous para says that.

Uh, well, the chart says it via syntax, which isn't exactly the same as
stating it, and this is particularly important because it is an odd
default.

I have created an updated paragraph for that section:

http://momjian.us/tmp/pgsql/datatype-datetime.html

Note: The SQL standard requires that writing just timestamp be
equivalent to timestamp without time zone, and PostgreSQL honors that
behavior. (Releases prior to 7.3 treated it as timestamp with time
zone).

Is that an improvement?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-02-24 17:30:03 Re: [COMMITTERS] pgsql: Move documentation of all recovery.conf option to a new chapter.
Previous Message Tom Lane 2010-02-24 16:59:00 Re: pgsql: Revert removal of pre-7.4 documenation behavior mentions.