elein <elein(at)varlena(dot)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