Re: FW: Re: Part 1 of several - Converting a varchar to an interval

-------------- Original message ----------------------
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> 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

Note to self:
Keep up with bug fixes.

--
Adrian Klaver
aklaver(at)comcast(dot)net