elein ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
