Re: Subqueryes

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.