Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 2DE211B9FDB0
	for <pgsql-sql@postgresql.org>; Wed,  4 Apr 2012 01:17:03 -0300 (ADT)
Received: from forward9.mail.yandex.net ([77.88.61.48])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <msi77@yandex.ru>) id 1SFHeV-00047d-Tj
	for pgsql-sql@postgresql.org; Wed, 04 Apr 2012 04:17:03 +0000
Received: from web118.yandex.ru (web118.yandex.ru [77.88.60.95])
	by forward9.mail.yandex.net (Yandex) with ESMTP id EB8F9CE223A;
	Wed,  4 Apr 2012 08:16:44 +0400 (MSK)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
	t=1333513005; bh=p45OZY5i+iyZOwbM/WhTKz/Diu0mHOK4yYU15gd/BF4=;
	h=From:To:Cc:In-Reply-To:References:Subject:MIME-Version:Message-Id:
	Date:Content-Transfer-Encoding:Content-Type;
	b=qX6KpZW8mbFFi4d8xwqofiLVm9BsPRJAGw2y113ekTUqRB5q3K2us8W2XEDR1WSDs
	j2W7cMmORFR5XxSgmDqDUN+ikk1ntE3DTa3pdVIJW60Pdhpmp/rn9EknaQfitx1BeY
	+0VgkN0fKK/NelbPgmZklepLeeYPegZSn6pI6hBw=
Received: from 127.0.0.1 (localhost.localdomain [127.0.0.1])
	by web118.yandex.ru (Yandex) with ESMTP id AEBE5A8005D;
	Wed,  4 Apr 2012 08:16:44 +0400 (MSK)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
	t=1333513004; bh=p45OZY5i+iyZOwbM/WhTKz/Diu0mHOK4yYU15gd/BF4=;
	h=From:To:Cc:In-Reply-To:References:Subject:MIME-Version:Message-Id:
	Date:Content-Transfer-Encoding:Content-Type;
	b=dvH9+k57B/kD/sJd+sVkTlGRKKwfkMpenJ743iWhztfuJYAsBKG7JQZLHTYEuQqL0
	Gc3HLCCT46pY34a2Gj5c4bwQyY69nmYvGxIklb7UZONebuGRVH++lEQO/QW/gGm9Hx
	nfXY7jx4L7s8sDtN4l+UULhjOxfP2TzC4aS460FI=
Received: from [2.92.165.156] ([2.92.165.156]) by web118.yandex.ru with HTTP;
	Wed, 04 Apr 2012 08:16:44 +0400
From: msi77 <msi77@yandex.ru>
To: JORGE MALDONADO <jorgemal1960@gmail.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: 
 <CAAY=A78k-evpWv5jC2TBst-ncN3tVXfK3POPdO3zr5ccOVKrtg@mail.gmail.com>
References: 
 <CAAY=A78k-evpWv5jC2TBst-ncN3tVXfK3POPdO3zr5ccOVKrtg@mail.gmail.com>
Subject: Re: Duplicate information in parent and child tables
MIME-Version: 1.0
Message-Id: <178541333513004@web118.yandex.ru>
Date: Wed, 04 Apr 2012 08:16:44 +0400
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: 0.3 (/)
X-Archive-Number: 201204/6
X-Sequence-Number: 36483

Maybe this will help http://sql-ex.ru/help/select18.php

04.04.2012, 02:03, "JORGE MALDONADO" <jorgemal1960@gmail.com>:
> I have a parent table and a child table. In order to detect duplicate i=
nformation I need to consider both tables. This means that a "duplicate r=
ecord" consists of one parent record and one or more child records.=9A Is=
 there any standard approach to solve this issue?
>
> Respectfully,
> Jorge Maldonado