update ... set ... subquery - Mailing list pgsql-general

guys,
trying multiple updates without success like so:

update    a
set        number = any (    select number from b where a.number=b.number)
where    number is null;
>> 'syntax error at or near "any"'

subquery returns more than one row. using 8.1.
thks, jzs