Re: Problems Formulating a SELECT - Mailing list 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