Thanks for taking a look at this guys. The file is sorted(indexed) md5sum + path + file_name
Therefore the longer path name (and more deeply nested) will be the last one and therefore the one retained. (That was my plan anyway.) No file removal will be done at this stage, the Boolean field "del" will be marked as true and then on another pass (after the results are inspected), the files belonging to the records marked for deletion will be moved (not deleted) to another place where another inspection will take place and after the unmoved files are backed up the moved files will be deleted. So to traverse this file and update it without loosing my place I am supposing I need one cursor to maintain my position and another (disposable one) to update the table when necessary. I wanted to know if I had misunderstood what I had read. My original questions were: Is the use of an AuxCursor the only way to do what I want to do (unless I can get the withhold attribute to behave)(psycopg2)? If there is another way, where is the best description of it so I can read about it? Thanks, Bill House On 05/03/2012 07:14 PM, John Fabiani wrote: > On Thursday, May 03, 2012 09:05:38 PM Ricardo Araoz wrote: >> El 03/05/12 10:05, John Fabiani escribió: >>> On Thursday, May 03, 2012 07:15:46 AM Ricardo Araoz wrote: >>>> Don't know if I understood what you want. I think you want to get rid >>>> of >>>> duplicate records. >>>> It it is so, then in SQL is really simple : >>>> >>>> select distinct * from TheTable >>>> >>>> T t t t that's all folks. >>> He wants all the dups removed but the last one. >>> >>> Johnf >> So I was right (the last one is the same as any other dup) the "select >> distinct" will do it easily. > As I understand it all but the last one - using distinct does not insure the > LAST ONE is saved. How he finds the last I'm not sure. > > Johnf > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users > Searchable Archives: http://leafe.com/archives/search/dabo-users > This message: http://leafe.com/archives/byMID/1935844.tM7pu1bqSp@linux-12 > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
