Re: Combinatorial problem

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.

--- Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:

> On 11/30/05 8:26 AM, "Srinivas Iyyer"
> <srini_iyyer_bio(at)yahoo(dot)com> wrote:
>
> > Dear Sean,
> > Thank you for your help.
> >
> > I have another question and sorry to bother you.
> If I
> > do not know the pairing before hand for drugs
> (such as
> > m1,m3 and m5) how can I define any random
> combination.
> > should it have to be solved using PL/PgSQL or just
> > through SQL queries?
>
> I'm not sure what you want to do--can you elaborate?
> Do you mean that you
> want to choose the drugs via some interface and then
> do the query with those
> drugs? Or something else? I'm not sure how
> PL/PgSQL would come into it.
>
> Sean
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>

__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com