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

Поиск
Список
Период
Сортировка
Искать

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

От:
momjian@postgresql.org (Bruce Momjian)
Дата:
Log Message:
-----------
Revert removal of pre-7.4 documenation behavior mentions.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        datatype.sgml (r1.243 -> r1.244)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml?r1=1.243&r2=1.244)
        ddl.sgml (r1.89 -> r1.90)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml?r1=1.89&r2=1.90)
        libpq.sgml (r1.301 -> r1.302)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml?r1=1.301&r2=1.302)
        protocol.sgml (r1.84 -> r1.85)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/protocol.sgml?r1=1.84&r2=1.85)
        rules.sgml (r1.54 -> r1.55)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/rules.sgml?r1=1.54&r2=1.55)
        xindex.sgml (r1.65 -> r1.66)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/xindex.sgml?r1=1.65&r2=1.66)

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

От:
Thom Brown <thombrown@gmail.com>
Дата:
On 24 February 2010 15:54, Bruce Momjian  wrote:
> Log Message:
> -----------
> Revert removal of pre-7.4 documenation behavior mentions.
>
> Modified Files:
> --------------
>    pgsql/doc/src/sgml:
>        datatype.sgml (r1.243 -> r1.244)
>        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml?r1=1.243&r2=1.244)

+      Prior to PostgreSQL 7.3, writing just
+      timestamp was equivalent to timestamp with
+      time zone.  This was changed for SQL compliance.

You may wish to say what exactly it was changed to.

Thom

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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Thom Brown  writes:
> On 24 February 2010 15:54, Bruce Momjian  wrote:
> +      Prior to PostgreSQL 7.3, writing just
> +      timestamp was equivalent to timestamp with
> +      time zone.  This was changed for SQL compliance.

> You may wish to say what exactly it was changed to.

The previous para says that.

			regards, tom lane

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

От:
Bruce Momjian <bruce@momjian.us>
Дата:
Tom Lane wrote:
> Thom Brown  writes:
> > On 24 February 2010 15:54, Bruce Momjian  wrote:
> > +      Prior to PostgreSQL 7.3, writing just
> > +      timestamp was equivalent to timestamp with
> > +      time zone.  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          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. +

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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Bruce Momjian  writes:
> I have created an updated paragraph for that section:

> 	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?

No objection here.

			regards, tom lane

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

От:
Thom Brown <thombrown@gmail.com>
Дата:
On 24 February 2010 17:07, Bruce Momjian  wrote:
> Tom Lane wrote:
>> Thom Brown  writes:
>> > On 24 February 2010 15:54, Bruce Momjian  wrote:
>> > +      Prior to PostgreSQL 7.3, writing just
>> > +      timestamp was equivalent to timestamp with
>> > +      time zone.  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?
>

Yes, that's clearer, even if that information is inferred in the table
above (my bad, I should have checked that too).

Thanks,

Thom

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

От:
Bruce Momjian <bruce@momjian.us>
Дата:
Thom Brown wrote:
> On 24 February 2010 17:07, Bruce Momjian  wrote:
> > Tom Lane wrote:
> >> Thom Brown  writes:
> >> > On 24 February 2010 15:54, Bruce Momjian  wrote:
> >> > + ? ? ?Prior to PostgreSQL 7.3, writing just
> >> > + ? ? ?timestamp was equivalent to timestamp with
> >> > + ? ? ?time zone. ?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?
> >
> 
> Yes, that's clearer, even if that information is inferred in the table
> above (my bad, I should have checked that too).

Thanks, applied.

-- 
  Bruce Momjian          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. +
FAQ