Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: aklaver(at)comcast(dot)net (Adrian Klaver)
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Date: Wed, 26 Mar 2008 14:14:35 -0400
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
- References:
- Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- From: Adrian Klaver
- Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Prev by Date: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Next by Date: Finding all References to a Primary Key
- Previous by thread: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Next by thread: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
- Indexes: