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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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




[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux