update multiple columns with multiple values

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.