| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Charles Hauser <chauser(at)duke(dot)edu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Problems Formulating a SELECT |
| Date: | 2002-10-09 08:47:15 |
| Message-ID: | 200210090947.15918.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rudi Starcevic | 2002-10-09 10:06:33 | PLPGSQL errors |
| Previous Message | Shridhar Daithankar | 2002-10-09 08:25:28 | Re: Large databases, performance |