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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
