Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 65E6E9FB1BA for ; Fri, 2 Feb 2007 11:17:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 91236-10 for ; Fri, 2 Feb 2007 11:16:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 418699FA22A for ; Fri, 2 Feb 2007 11:16:56 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HD0L0-00086C-BZ for pgsql-sql@postgresql.org; Fri, 02 Feb 2007 10:28:30 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 8057B3FAF; Fri, 2 Feb 2007 10:16:44 -0500 (EST) Date: Fri, 2 Feb 2007 10:16:44 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Duplicate records Message-ID: <20070202151644.GA11199@phlogiston.dyndns.org> References: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com> <45C350D8.A3DD.0030.0@indicator.be> <55c095e90702020559t27296667g5a46aca1b5386679@mail.gmail.com> <55c095e90702020700v4e84c5e7n4e8116645c67a5af@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <55c095e90702020700v4e84c5e7n4e8116645c67a5af@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/19 X-Sequence-Number: 27353 > > ps: I just think postresql could make this easyly. Don't you think ? Any > function or anything else. What's hard about the self-join? That's how SQL works. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes