On Wed, Mar 17, 2010 at 03:13:26PM -0400, John Smith wrote: > 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
make is: number in ( select number from ... number = any () is syntax for arrays. depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
