Re: Can interval take a value from a field?

Jeff Davis wrote:
> 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
>

Thank you! That combined with the subselect wrapper trick I learned
last time I visited the list hat in hand worked wonderfully.

Jeff