Osvaldo Rosario Kussama escreveu:
> Tente:
> UPDATE teste SET coluna1 = t_aux.coluna1+1
> FROM (
>          SELECT coluna1
>            FROM teste
>            ORDER BY coluna1 DESC
>       ) t_aux
> WHERE teste.coluna1 = t_aux.coluna1;
>
>   
Osvaldo
Mesmo assim dá chave duplicada |
mas valew pela tentativa !

-- 

Evandro Andersen
(43)3323-4641 - (43)9125-6752
msn: [EMAIL PROTECTED]

Power Cobol 5.0
Crystal Reports 8.5
Postgresql 8.2.5
Windows 2003 Server SP2

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a