-------------- Original message ----------------------
From: Tom Lane <tgl@[EMAIL PROTECTED]
>
> aklaver@[EMAIL PROTECTED]
(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
Note to self:
Keep up with bug fixes.
--
Adrian Klaver
aklaver@[EMAIL PROTECTED]
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql