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.
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.
pgsql-sql by date
|Next:||From: Bear||Date: 2012-02-08 07:48:51|
|Subject: Re: problem with nested dblink function|
|Previous:||From: Bear||Date: 2012-02-07 14:00:50|
|Subject: problem with nested dblink function|