Hello,
I thought I had some experience with plpgsql functions by now. However, w=
hen trying to do this query (generic column/table names):
UPDATE table_a cus SET spalte1 =3D ( SELECT spalte1 FROM table_a_copy cl =
WHERE cl.tabname =3D cus.tabname );
from within a plpgsql funtion I get the error message:
'more than row returned by a subquery used as an expression'.
This even happens when I put the query into a string that I let be EXECUT=
Eed.
I works without errors and seemingly the way I wanted when doing the upda=
te separately.
Before I create a copy of table_a with:
CREATE TABLE table_a_copy AS SELECT * FROM table_a;
Then I load the backed up data with COPY to table_a_copy.
Then I do the update(s).
Of course one could do the updates with a loop, but in my opinion that's =
rather inconvenient.
Any hints what the problem is?
Thank you very much,
Peter
P.S. Server version 8.3.11. The name of the schema is different from publ=
ic so I'm using 'set search_path TO ...'.
--
GRATIS f=C3=BCr alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
