Re: [SQL] Subqueryes

[Richard Broersma Jr]

> 
> 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