Re: [SQL] De-duplicating rows

2009-07-17 Thread Richard Huxton
Christophe wrote: The Subject: is somewhat imprecise, but here's what I'm trying to do. For some reason, my brain is locking up over it. I'm moving a 7.2 (yes) database to 8.4. Big leap. Allow some time for testing your application. I'm not sure if 7.2 even supported schemas, and there's

Re: [SQL] De-duplicating rows

2009-07-17 Thread Frank Bax
Richard Huxton wrote: Christophe wrote: Now, since this database has been production since 7.2 days, cruft has crept in: in particular, there are duplicate email addresses, some with mismatched attributes. The policy decision by the client is that the correct row is the one with the earliest

Re: [SQL] De-duplicating rows

2009-07-17 Thread Scott Marlowe
On Thu, Jul 16, 2009 at 9:07 PM, Christophex...@thebuild.com wrote: The Subject: is somewhat imprecise, but here's what I'm trying to do.  For some reason, my brain is locking up over it. I'm moving a 7.2 (yes) database to 8.4.  In the table in question, the structure is along the lines of: