From: | "Jim Wilson" <jimw(at)kelcomaine(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Casting varchar to interval.? |
Date: | 2004-01-26 14:43:38 |
Message-ID: | twig.1075128218.74761@kelcomaine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is this a bug? You can work around it by wrapping the varying in a trim()
function (e.g. select trim(config_value)::interval from config). I've solved
another suspicious looking issue with that same kind of workaround.
Best regards,
Jim Wilson
"D. Dante Lorenso" <dante(at)lorenso(dot)com> said:
> I was hoping to cast a varchar to an interval.
> How is this done? Nobody has provided an answer to
> this questing when asked in the past:
>
> http://archives.postgresql.org/pgsql-general/2002-07/msg01482.php
>
> I have a table 'config' that contains:
>
> CREATE TABLE "public"."config" (
> "config_key" VARCHAR(64) NOT NULL,
> "config_value" VARCHAR(256) NOT NULL,
> PRIMARY KEY("config_key")
> ) WITH OIDS;
>
> So I can do this:
>
> # SELECT config_value
> # FROM config
> # WHERE config_key = 'commission_withhold_interval';
> config_value
> --------------
> 1 month
> (1 row)
>
> But I can't do this:
>
> # SELECT config_value::interval
> # FROM config
> # WHERE config_key = 'commission_withhold_interval';
>
> ERROR: cannot cast type character varying to interval
>
> Why doesn't that work?
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2004-01-26 15:03:40 | Re: Object Relational features in PostgreSQL |
Previous Message | Tom Lane | 2004-01-26 14:25:29 | Re: FAQ (disk space) |