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

[Archana K N <archanakknn@xxxxxxxxx>]

Hello,

     I am trying to update a database with values from another . Am using Debain(Linux) OS.

        When I try to update no error is displayed. But column is not updated.

I am using the psql console for querying.

my code is as follows(along with result):-

""my_db=# update test set id=g.id2 from (select id2 from test2)as g ;

UPDATE 0

""

 

Thanks in advance............

--
-------------------
regards
archana
--------------------