Re: UPDATE (SELECT ) is not working................

On 17/01/14 21:28, Archana K N wrote:

>
> ""*/my_db=# update test set id=g.id2 from (select id2 from test2)as g ;/*
> */UPDATE 0/*
> ""
>

'UPDATE 0' means 0 rows where found to update. So everything is working
fine, but your query search criteria is finding no candidate rows to
change. This is purely a data issue.

Regards

Mark