Duplicate information in parent and child tables

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Duplicate information in parent and child tables
Date: 2012-04-03 22:03:41
Message-ID: CAAY=A78k-evpWv5jC2TBst-ncN3tVXfK3POPdO3zr5ccOVKrtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a parent table and a child table. In order to detect duplicate
information I need to consider both tables. This means that a "duplicate
record" consists of one parent record and one or more child records.
Is there any standard approach to solve this issue?

Respectfully,
Jorge Maldonado

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message msi77 2012-04-04 04:16:44 Re: Duplicate information in parent and child tables
Previous Message Jasen Betts 2012-04-03 10:49:23 Re: Wrong output from union