Re: FW: Re: Part 1 of several - Converting a varchar to an interval - Mailing list pgsql-sql

-------------- Original message ----------------------
From: Tom Lane <tgl@sss.pgh.pa.us>
> aklaver@comcast.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@comcast.net