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

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
--------------------

Responses

Browse pgsql-php by date

  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