Re: Subqueryes

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