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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
