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