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

--089e013a0b1a7ae59704f026537d
Content-Type: text/plain; charset=ISO-8859-1

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

--089e013a0b1a7ae59704f026537d
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>=A0 =A0 =A0I am trying to update=
 a database with values from another . Am using Debain(Linux) OS.</div><div=
><br></div><div>=A0 =A0 =A0 =A0 When I try to update no error is displayed.=
 But column is not updated.</div>
<div>I am using the psql console for querying.</div><div><br></div><div>my =
code is as follows(along with result):-</div><div><br></div><div>&quot;&quo=
t;<b><i>my_db=3D# update test set id=3Dg.id2 from (select id2 from test2)as=
 g ;</i></b></div>
<div><b><i>UPDATE 0</i></b></div><div>&quot;&quot;</div><div>=A0<br clear=
=3D"all"><div>Thanks in advance............</div>-- <br>-------------------=
<br>regards<br>archana<br>--------------------
</div></div>

--089e013a0b1a7ae59704f026537d--