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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html