Re: Can interval take a value from a field?

On Tue, 2008-09-09 at 17:03 -0600, Jeff Ross wrote:
> select
>          ts_date as "Transcript Date",
>          ts_expiration_date as "Current Expiration Date",
>          expiration_value as "Expiration Interval"
>          from transcript, training_expiration_value where
>          ts_training_id = trgexpd_trg_id and
>          ts_training_id in (select cda_training_number from cdas) and
>          ts_expiration_date != ts_date + interval 'expiration_value';
>
> and I'm getting the following error:
>
> ERROR:  invalid input syntax for type interval: "expiration_value"

This error is saying that it is trying to convert the string
'expiration_value' to an interval.

What you really want it to convert the string value held inside a
variable named "expiration_value" to an interval.

For that, you need to do expiration_value::interval

Regards,
    Jeff Davis