interval( 'seconds 27960' ) is broken

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: interval( 'seconds 27960' ) is broken
Date: 2001-05-08 00:33:42
Message-ID: 200105080033.f480Xgd87288@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

elein (elein(at)nextbus(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
interval( 'seconds 27960' ) is broken

Long Description
In 7.0.3, I'm converting seconds from midnight to a time of
day using interval ( 'seconds <val>'). This worked fine in
7.0.3 and gives a Bad interval external representation message
in 7.1.

I'm marking this devastating because it falls under the criteria of not being able to input valid data. And my
application depends on this conversion.

I see there were a lot of clean up changes in the date/time/stamp functions, but was not able to pinpoint
the change that caused the problem.

A good workaround would reduce this problem to major annoyance.

Sample Code
In 7.0.3:
elein=# select interval( 'seconds 27960');
?column?
----------
07:46
(1 row)

In 7.1:
elein=# select interval( 'seconds 27960');
ERROR: Bad interval external representation 'seconds 27960'

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-05-08 00:54:14 Re: backend dies on 7.1.1 loading large datamodel.
Previous Message Bruce Momjian 2001-05-08 00:28:58 Re: RAISE concatination/variables in plpgsql