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 -- Sent via pgsql-php mailing list (pgsql-php@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php