Casting varchar to interval - Mailing list pgsql-general

From Chris
Subject Casting varchar to interval
Date
Msg-id MWMail.pramtgee@host.none
Whole thread Raw
List pgsql-general
Greetings:

I'm trying to store a timeout value into a settings table:
  create table settings(
    stattr varchar(25),
    stvalue varchar(25));
  insert into settings(stattr, stvalue) values ('timeout', '1 hr');

I would like to determine if this time has elapsed:
  select selasthit - stvalue::interval as thetime from sessions, settings;
(obviously, there's only one row in my settings table for testing purposes)

I keep getting:
ERROR:  Cannot cast type 'character varying' to 'interval'

Can anyone suggest a solution?

Thanks
Chris

pgsql-general by date:

Previous
From: miguel angel rojas aquino
Date:
Subject: Re: error modifying max_connections (maybe a little o.t.)
Next
From: Robert Treat
Date:
Subject: Re: Postgres 7.3