Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Re: FW: Re: Par...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3369 of 3799
Post > Topic >>

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

by aklaver@[EMAIL PROTECTED] (Adrian Klaver) Mar 26, 2008 at 08:02 PM

-------------- Original message ----------------------
From: Tom Lane <tgl@[EMAIL PROTECTED]
>
> aklaver@[EMAIL PROTECTED]
 (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@[EMAIL PROTECTED]
 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
 




 1 Posts in Topic:
Re: FW: Re: Part 1 of several - Converting a varchar to an inter
aklaver@[EMAIL PROTECTED]  2008-03-26 20:02:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 21:55:48 CST 2008.