Обсуждение: update error

Поиск
Список
Период
Сортировка

update error

От
"guard"
Дата:
I try

update table_a set trn_no = table_b.trn_no from table_a,table_b
where table_a.cust_no=table_b.cust_no

IN pgsql 7.0x  IS OK

if run 7.1 IS error ??

Re: update error

От
Tom Lane
Дата:
"guard" <guard@ficnet.net> writes:
> update table_a set trn_no = table_b.trn_no from table_a,table_b
> where table_a.cust_no=table_b.cust_no

> IN pgsql 7.0x  IS OK

> if run 7.1 IS error ??

More details please?
        regards, tom lane