From: Richard Huxton <dev@archonet.com>
To: Charles Hauser <chauser@duke.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problems Formulating a SELECT
Date: Wed, 9 Oct 2002 09:47:15 +0100
Message-ID: <200210090947.15918.dev@archonet.com> (raw)
In-Reply-To: <1034101155.4283.78.camel@pandorina.biology.duke.edu>
References: <1034018651.2282.38.camel@pandorina.biology.duke.edu>
<200210081744.15596.dev@archonet.com>
<1034101155.4283.78.camel@pandorina.biology.duke.edu>
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 join
has less rows to compare against.
> chlamy_est-> ;
> contig_id
> -----------
> 27170
> 27173
> 27173
> 27179
> 27179
> 27179
> 27179
> 27179
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, chauser@duke.edu
Subject: Re: Problems Formulating a SELECT
In-Reply-To: <200210090947.15918.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox