From: chang4@cox.net   
      
   You can create a temporary trigger that fires on updates.  It will be   
   somewhat similar to your insert trigger, e.g.   
     if (:new.id = -1) then   
       :new.id := seq_name@nextval;   
      
   Then, just update your whole table:   
     update tablename   
          set id = -1;   
      
   Remove the temporary update trigger after that.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)