| From: | Archana K N <archanakknn(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQLPHP PostgreSQLPHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | UPDATE (SELECT ) is not working................ |
| Date: | 2014-01-17 08:28:26 |
| Message-ID: | CACa6=i2M7HRJDpJRwZj6ckotLe9nRd9TgAi8_cdFiVg-S92ijA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
Hello,
I am trying to update a database with values from another . Am using
Debain(Linux) OS.
When I try to update no error is displayed. But column is not
updated.
I am using the psql console for querying.
my code is as follows(along with result):-
""*my_db=# update test set id=g.id2 from (select id2 from test2)as g ;*
*UPDATE 0*
""
Thanks in advance............
--
-------------------
regards
archana
--------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McMillan | 2014-01-17 09:04:11 | Re: UPDATE (SELECT ) is not working................ |
| Previous Message | Mark Kirkwood | 2014-01-12 08:59:01 | Re: Unbuffered queries |