On 17 Mar 2010, at 21:40, John Smith wrote:
> guys,
> sorry my query is like so:
> update a
> set number = any ( select number from b where a.name=b.name )
> where number is null;
>
Looks like you want:
update a
set number = b.number
from b
where number is null
and name = b.name;
> sim
guys,
sorry my query is like so:
update a
set number = any ( select number from b where a.name=b.name )
where number is null;
simplified table a:
sn | number| name
--
1 | 101 | john
2 | null | mary
3 | 127
On Wed, Mar 17, 2010 at 03:13:26PM -0400, John Smith wrote:
> guys,
> trying multiple updates without success like so:
>
> updatea
> set number = any ( select number from b where a.number=b.number)
> where number is null;
> >> 'syntax error at or near "any"'
>
> subquery return
2010/3/17 John Smith
> 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,
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 li
