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: Dabo-users@leafe.com

> 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: Dabo-users@leafe.com

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/4FA32BB4.50303@house-grp.net