Re: 7.3 interval casting broken (7.4 OK)

elein <elein@varlena.com> writes:
> The interval casting in 7.3 is ignoring precision.

Yeah, see this fix:

2003-01-08 19:58  tgl

    * src/include/catalog/pg_proc.h: Add missing pg_proc entry for
    interval_scale().  The lack of this entry causes interval rounding
    not to work as expected in 7.3, for example SELECT
    '18:17:15.6'::interval(0) does not round the value.  I did not
    force initdb, but one is needed to install the added row.

We couldn't back-patch that into 7.3 without an initdb, unfortunately.

            regards, tom lane