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
