| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Charles Hauser <chauser(at)duke(dot)edu>, PSQL_list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: help w/ constructing a SELECT |
| Date: | 2002-09-19 23:40:50 |
| Message-ID: | 200209191640.50353.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | alexandre :: aldeia digital | 2002-09-20 00:31:29 | Query Freeze |
| Previous Message | Dmitry Tkach | 2002-09-19 22:48:16 | Re: Table Copy. |