>
> update myTable
> set date = (current_date + (Select daysToAdd from base.Table1 where
> myFKey_id = Table1Id) )
> where Expire_Date = now()::Date;
Does this work: http://www.postgresql.org/docs/8.2/interactive/sql-update.html
UPDATE myTable
SET date = current_date + B.daysToAdd
FROM Table1 B
WHERE myFKey_id = B.Table1Id;
Regards,
Richard Broersma Jr.