Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4638D2E00C2 for ; Wed, 26 Mar 2008 15:15:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 32727-01-5 for ; Wed, 26 Mar 2008 15:15:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A7E202E2F01 for ; Wed, 26 Mar 2008 15:14:42 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2QIEZHm000907; Wed, 26 Mar 2008 14:14:35 -0400 (EDT) To: aklaver@comcast.net (Adrian Klaver) cc: pgsql-sql@postgresql.org Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval In-reply-to: <032620081730.4863.47EA8835000C8D51000012FF22069997359D0A900E04050E@comcast.net> References: <032620081730.4863.47EA8835000C8D51000012FF22069997359D0A900E04050E@comcast.net> Comments: In-reply-to aklaver@comcast.net (Adrian Klaver) message dated "Wed, 26 Mar 2008 17:30:29 -0000" Date: Wed, 26 Mar 2008 14:14:35 -0400 Message-ID: <906.1206555275@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/182 X-Sequence-Number: 30510 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