postgreSQL中update set a=(select ) 应该如何写?
update test1 a
set name= (select name from test2 b where a.age=b.age)