Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C9677474E5C for ; Wed, 9 Oct 2002 04:59:47 -0400 (EDT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id D5468476264 for ; Wed, 9 Oct 2002 04:59:45 -0400 (EDT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 17zCh0-0006WG-0U; Wed, 09 Oct 2002 09:59:47 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id BE2B015958; Wed, 9 Oct 2002 09:47:29 +0100 (BST) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 2C13815956; Wed, 9 Oct 2002 09:47:29 +0100 (BST) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Charles Hauser Subject: Re: Problems Formulating a SELECT Date: Wed, 9 Oct 2002 09:47:15 +0100 User-Agent: KMail/1.4.3 Cc: pgsql-sql@postgresql.org References: <1034018651.2282.38.camel@pandorina.biology.duke.edu> <200210081744.15596.dev@archonet.com> <1034101155.4283.78.camel@pandorina.biology.duke.edu> In-Reply-To: <1034101155.4283.78.camel@pandorina.biology.duke.edu> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210090947.15918.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/119 X-Sequence-Number: 9836 On Tuesday 08 Oct 2002 7:19 pm, Charles Hauser wrote: > Richard, > [snip] > Is there a method to remove duplicate results? For instance the query > below in part yields : SELECT DISTINCT ... is what you're after. I'd do it in the views so the joi= n=20 has less rows to compare against. > chlamy_est-> ; > contig_id > ----------- > 27170 > 27173 > 27173 > 27179 > 27179 > 27179 > 27179 > 27179 --=20 Richard Huxton