[SQL] How to update multiple rows

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

Re: [SQL] [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 able to understand.Please alter my code. (select kasarano from parcelsdata), murabano=(select murabano from parcelsdata), the_geom = (select (st_

[SQL] Different plan for one query problem

Hello! I have following query: SELECT db_oks_zu."tbl_location"."full_address", db_class."kladrCache"."region", db_class."kladrCache"."mo", db_class."kladrCache"."city", db_class."kladrCache"."street", db_oks_zu."tbl_location"."house", db_oks_zu."tbl_position"."number_flat", ((COALESCE(db_oks_z