Hi list,
I must add some days (i.e:365) to my current_date and put it in my table
(an UPDATE). By now, it is simple but my "days to add" is in another table.
How could I do this kind of update
My sql is like this (but is not working):
update myTable
set date = (current_date + (Select daysToAdd from base.Table1 where
myFKey_id = Table1Id) )
where Expire_Date = now()::Date;
--
Atenciosamente
Ezequias Rodrigues da Rocha
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
