Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 5F3B3133798E
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 24 Sep 2010 14:57:45 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 24605-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 24 Sep 2010 17:57:38 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from zebedee.cranntara.net (zebedee.cranntara.net [91.186.7.79])
	by mail.postgresql.org (Postfix) with ESMTP id 54115133729E
	for <pgsql-sql@postgresql.org>; Fri, 24 Sep 2010 14:57:37 -0300 (ADT)
Received: from [88.210.158.208] (helo=bolek.coachhouse)
	by zebedee.cranntara.net with esmtpsa (TLS1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.69) (envelope-from <postgresql@numerixtechnology.de>)
	id 1OzCWd-0003VQ-Rj
	for pgsql-sql@postgresql.org; Fri, 24 Sep 2010 18:57:37 +0100
Received: from [192.168.0.32] (helo=dick.coachhouse ident=tarlika)
	by bolek.coachhouse with esmtp (Exim 4.69)
	(envelope-from <postgresql@numerixtechnology.de>) id 1OzCFE-0003lq-Mo
	for pgsql-sql@postgresql.org; Fri, 24 Sep 2010 18:39:36 +0100
Date: Fri, 24 Sep 2010 18:39:36 +0100
From: Tarlika Elisabeth Schmitz <postgresql@numerixtechnology.de>
To: "<pgsql-sql@postgresql.org>" <pgsql-sql@postgresql.org>
Subject: Re: identifying duplicates in table with redundancies
Message-ID: <20100924183936.073a8238@dick.coachhouse>
In-Reply-To: <065CBEA1-1647-4233-BBB6-48E879FD91B0@gmail.com>
References: <20100923223940.5019475e@dick.coachhouse>
	<8590CAE9E5504E23AB08C4EF31EA066F@marktestcr.marktest.pt>
	<20100924171226.6000b310@dick.coachhouse>
	<065CBEA1-1647-4233-BBB6-48E879FD91B0@gmail.com>
X-Mailer: Claws Mail 3.5.0 (GTK+ 2.12.12; i486-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201009/105
X-Sequence-Number: 34636

Hello Oliveiros,


On Fri, 24 Sep 2010 18:12:18 +0100
Oliver d'Azevedo Christina <oliveiros.cristina@gmail.com> wrote:

>Hey,Tarlika.
>I tried to reproduce your test case through a series of inserts and
>It seems that the lower case "d" went unnoticed.

I can assure you people up here (in Scotland) get quite upset about it!

It took me  a while to get my head round your outer query with the
NATURAL JOIN between the student table and the nested query results. I
have done table joins before but this solution would not have sprung to
mind.

-- 

Many thanks,
Tarlika Elisabeth Schmitz