Re: [HACKERS] bug or change in functionality in 7.2?

On Mon, 19 Nov 2001 11:24:08 EST, Tom Lane wrote:
> F Harvell <fharvell(at)fts(dot)net> writes:
> > In my experiences with other databases, the notations indicated in
> > the Date/Darwin book do indeed work whereas the PostgreSQL notation
> > (with the closing single quote following the start to end
> > specification) do not work.
>
> In current sources:
>
> regression=# select INTERVAL '2:12:35' HOUR TO SECOND;
> interval
> ----------
> 02:12:35
> (1 row)
>
> regression=# select INTERVAL '2:12:35 HOUR TO SECOND';
> ERROR: Bad interval external representation '2:12:35 HOUR TO SECOND'
> regression=#
>
> Looks like Lockhart agrees with you ;-)
>

If the above is true (i.e., errors on the second interval literal), it
should probably be mentioned in the release notes (HISTORY file?).
While I eagerly anticipate the change and agree with it, it will break
a lot of my current code. I think this is (potentially) correct,
however, it should be told to people who are using interval literals
and anticipating to make the upgrade to 7.2.

--
Mr. F Harvell Phone: +1.407.673.2529
FTS International Data Systems, Inc. Cell: +1.407.467.1919
7457 Aloma Ave, Suite 302 Fax: +1.407.673.4472
Winter Park, FL 32792 mailto:fharvell(at)fts(dot)net

> If the above is true (i.e., errors on the second interval literal), it
> should probably be mentioned in the release notes (HISTORY file?).
> While I eagerly anticipate the change and agree with it, it will break
> a lot of my current code. I think this is (potentially) correct,
> however, it should be told to people who are using interval literals
> and anticipating to make the upgrade to 7.2.

Can I have some text for HISTORY?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> If the above is true (i.e., errors on the second interval literal), it
>> should probably be mentioned in the release notes (HISTORY file?).

> Can I have some text for HISTORY?

Thomas would be the authority, but AFAIK this is new stuff; it doesn't
break anything that worked before.

regards, tom lane

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> If the above is true (i.e., errors on the second interval literal), it
> >> should probably be mentioned in the release notes (HISTORY file?).
>
> > Can I have some text for HISTORY?
>
> Thomas would be the authority, but AFAIK this is new stuff; it doesn't
> break anything that worked before.

Oh, OK.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026