Dear list,
I am trying to update all rows of a column ('parent') based on a subquery
that returns me the first four digits of another column ('id'):
After executing, I get the following error-message:
I am not quite sure about that, but maybe I need to construct a function to
fulfill this task?
thanks for help.
Stefan
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/update-multiple-columns-with-multiple-values-tp5465796p5465796.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
