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

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Archana K N <archanakknn(at)gmail(dot)com>, PostgreSQLPHP PostgreSQLPHP <pgsql-php(at)postgresql(dot)org>
Subject: Re: UPDATE (SELECT ) is not working................
Date: 2014-01-17 09:33:02
Message-ID: 52D8F8CE.4080502@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Archana K N 2014-01-22 12:21:20 Data missing from table........
Previous Message Archana K N 2014-01-17 09:16:37 Re: UPDATE (SELECT ) is not working................