Ezequias R. da Rocha wrote:
> 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;
So what is the error message?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.