Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Date
Msg-id 906.1206555275@sss.pgh.pa.us
Whole thread Raw
In response to Re: FW: Re: Part 1 of several - Converting a varchar to an interval  (aklaver@comcast.net (Adrian Klaver))
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Next
From: "Matthew T. O'Connor"
Date:
Subject: Finding all References to a Primary Key