aklaver(at)comcast(dot)net (Adrian Klaver) writes:
> Select 134987 * interval '1 msec';
> ERROR: invalid input syntax for type interval: "1 msec"
> SELECT version();
> version
> ------------------------------------------------------------------------------------------------
> PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
8.2.3 is your problem --- this is fixed in 8.2.5 and up:
http://archives.postgresql.org/pgsql-committers/2007-05/msg00345.php
regards, tom lane