In Postgres vreau sa elimin dintr-o relatie tuplele duplicate. In "my good old Ingres" asta se facea simplu cu o comanda "modify relation to isam on key" (care le mai si ordona dupa key) . In postgres in afara de secventa : select distinct * into rel_tmp from rel; drop table rel; alter table rel_tmp rename to rel; nu exista o cale mai simpla ?? 10X -- ------------------------------------------------------- Constantin Vasiliu * StipoSoft System Administrator [EMAIL PROTECTED] * Linux Registered User #166419 -- tel:031/610215 ------------------- fax:031/610017 -- --- Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to unsubscribe from this list.
