Re: help w/ constructing a SELECT - Mailing list pgsql-sql

From Josh Berkus
Subject Re: help w/ constructing a SELECT
Date
Msg-id 200209191640.50353.josh@agliodbs.com
Whole thread Raw
In response to help w/ constructing a SELECT  (Charles Hauser <chauser@duke.edu>)
List pgsql-sql
Charles,

> Having a problem with a query.
> I would like to construct a query which will return a list of all
> contigs which are comprised of clones whose 'read' = 'x' (read can be
> either 'x' or 'y').

It appears that you haven't formulated clearly what you want to get.  I can
see 3 possibilities:

1. All contigs with one or more clones whose read = 'x' and those clones.
2. All contigs with one or more clones whose read = 'x' and all of those
contig's clones
3. All contigs where all clones have read = 'x'

Which do you want?

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Table Copy.
Next
From: "alexandre :: aldeia digital"
Date:
Subject: Query Freeze