Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE (SELECT ) is not working................ - Mailing list pgsql-php

From Mark Kirkwood
Subject Re: UPDATE (SELECT ) is not working................
Date
Msg-id 52D8F8CE.4080502@catalyst.net.nz
Whole thread Raw
In response to UPDATE (SELECT ) is not working................  (Archana K N <archanakknn@gmail.com>)
List pgsql-php
Tree view 
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

pgsql-php by date:

Previous
From: Archana K N
Date:
Subject: Re: UPDATE (SELECT ) is not working................
Next
From: Archana K N
Date:
Subject: Data missing from table........