Perfect quite nice. I am doing things that I could not believe I could
do without the community.
Thank you so much.
--
Atenciosamente
Ezequias Rodrigues da Rocha
Richard Broersma Jr escreveu:
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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
