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

Mark Kirkwood <[email protected]> Fri, 17 Jan 2014 22:33:02 +1300

Newsgroups	gmane.comp.db.postgresql.php
Message-ID	<[email protected]>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php