Home > mailing lists

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

From	Archana K N
Subject	UPDATE (SELECT ) is not working................
Date	January 17, 2014 11:28:31
Msg-id	CACa6=i2M7HRJDpJRwZj6ckotLe9nRd9TgAi8_cdFiVg-S92ijA@mail.gmail.com Whole thread Raw
Responses	Re: UPDATE (SELECT ) is not working................ (Andrew McMillan <andrew@morphoss.com>) Re: UPDATE (SELECT ) is not working................ (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List	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: Mark Kirkwood
Date: 12 January 2014, 11:59:13
Subject: Re: Unbuffered queries

From: Andrew McMillan
Date: 17 January 2014, 12:04:21
Subject: Re: UPDATE (SELECT ) is not working................