Re: help w/ constructing a SELECT

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: help w/ constructing a SELECT
Дата
Msg-id 200209191640.50353.josh@agliodbs.com
обсуждение исходный текст
Ответ на help w/ constructing a SELECT  (Charles Hauser <chauser@duke.edu>)
Список 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 по дате отправления:

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: Table Copy.
Следующее
От: "alexandre :: aldeia digital"
Дата:
Сообщение: Query Freeze