From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Combinatorial problem |
Date: | 2005-11-30 14:09:48 |
Message-ID: | BFB31CDC.13C61%sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 11/30/05 8:57 AM, "Srinivas Iyyer" <srini_iyyer_bio(at)yahoo(dot)com> 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.
I see your problem. I don't see how to do this off the top of my head.
However, I do agree that you will not likely be able to do this with
straight SQL, as you suspect. You might try posting to pgsql-sql list, as
well, if you don't get an answer here.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Marcus Engene | 2005-11-30 14:35:58 | Re: Combinatorial problem |
Previous Message | Srinivas Iyyer | 2005-11-30 13:57:42 | Re: Combinatorial problem |