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

Hi,

Sorry it is not 'database' ,but 'table' . I followed the syntax given

*UPDATE table_name SET(columns) FROM (SELECT columns FROM table_2) AS
som-val WHERE condition;*

And I tried it in psql command line as

my_db=# update test set id=g.id2 from (select id2 from test2)as g ;
UPDATE 0

where my_db is the database I created.

regards
archana

On Fri, Jan 17, 2014 at 2:34 PM, Andrew McMillan <andrew(at)morphoss(dot)com>wrote:

> On Fri, 2014-01-17 at 13:58 +0530, Archana K N wrote:
> > 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
>
> Your SQL does not do what you think it does.
>
> You should probably test your SQL at the psql command line to figure out
> the correct way to do what you want to do before you try and post to a
> PHP mailing list about this kind of thing.
>
> I'd offer advice, but I can't figure out from your statement what you're
> trying to do your database either.
>
> Cheers,
> Andrew.
>
>
> --
> ------------------------------------------------------------------------
> andrew (AT) morphoss (DOT) com +64 (2) 7233 2426
> IOT trap -- core dumped
> ------------------------------------------------------------------------
>
>
>
>
> --
> Sent via pgsql-php mailing list (pgsql-php(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php
>

--
-------------------
regards
archana
--------------------