lf Of venkat
Sent: Tuesday, October 26, 2010 2:15 AM
To: Alban Hertroys
Cc: pgsql-general@postgresql.org; pgsql-...@postgresql.org
Subject: Re: [GENERAL] How to update multiple rows
Dear Alban,
Thanks for your great response.I am not able to compile the query which you
have given..I am not ab
Dear Alban,
Thanks for your great response.I am not able to compile the query which you
have given..I am not able to understand.Please alter my code.
(select kasarano from parcelsdata),
murabano=(select murabano from parcelsdata),
the_geom = (select
(st_
On 26 Oct 2010, at 9:07, venkat wrote:
> Dear All,
>
> I want to update multiple row in single query.I am trying for below query.I
> am getting error as
>
> "ERROR: more than one row returned by a subquery used as an expression
> SQL state: 21000"
You're probably looking for UPDATE table F
Dear All,
I want to update multiple row in single query.I am trying for below
query.I am getting error as
"ERROR: more than one row returned by a subquery used as an expression
SQL state: 21000"
Here is my Query.
update parcelsdata set gid=(select random() * 10),
kasarano=(select kasar
