Re: Combinatorial problem

From: Marcus Engene <mengpg(at)engene(dot)se>
To: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Combinatorial problem
Date: 2005-11-30 14:35:58
Message-ID: 438DB8CE.9090003@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Srinivas Iyyer wrote:
> Sorry for being unclear.
>
> As of now from the whole mess of data, I do not know
> which targets are acted unique by a drug.
>
> For instance, Drug m134 is acting only on target T432,
> T438,T654.
> these targets are affected only by drug m134 and
> nothing else.
>
> Similarly, two drugs, m23 and m45 are acting on a
> group of targets, T987, T12,T334, T543.
>
> m2,m3 and m5 are acting on T439,3421,T4568,T31
> m2,m3 and m8 are acrting on T124, T1334,T446,T98.
> m5,m8 and m12 are acting on T088,T898,T329.
>
> Now, I have no idea what combination of drugs are
> acting on set of targets.
>
> IS there any way to get set of drugs and set of
> targets that happening in the data.
>
> What I mean to ask is, does it need a program such as
> Pl/pgsql to solve. I am nervous, because if it has to
> be done like that it is going to take long long time
> because, I have to learn it first.
>
> Thank you.

Hi Srinivas,

Perhaps this is what you want:

select *
from (
select distinct
drug_id,
array (select cb2.target_id
from comb cb2
where cb2.drug_id = cb.drug_id) as the_arr
from comb cb
) as foo
order by the_arr, drug_id

Best regards,
Marcus

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Srinivas Iyyer 2005-11-30 18:40:43 Re: Combinatorial problem
Previous Message Sean Davis 2005-11-30 14:09:48 Re: Combinatorial problem