[BUGS] Re: Problems with avg on interval data type

2001-05-18 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> I suggest that the current code is more correct than you think ;-). >> ISTM it is a good idea to require a units field, or at least some >> punctuation giving a clue about units --- for example I do not object to >> '08:00' being interpreted as hours

[BUGS] Re: Problems with avg on interval data type

2001-05-18 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: >> We have recently upgraded from 7.0.3 to 7.1 and a query which used >> to work is no longer working. >> The query does an avg on an interval column and now gets the error: >> ERROR: Bad interval external representation '0' > OK, there is one case of