Skip site navigation (1) Skip section navigation (2)

Re: Combinatorial problem

From: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Combinatorial problem
Date: 2005-11-30 13:26:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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?


>  select target_name
>  from drug, target, comb
>  where drug.drug_id=comb.drug_id and
>  comb.target_id=target.target_id and
>  drug_name in ('m1','m3','m5');

> Three points:  In postgresql, capital letters in
> column names and table
> names are folded to lower case if you don't use ""
> around them ALL THE TIME.
> Therefore, I tend to not use any capitals.  Second,
> there are a number of
> good SQL tutorials online that will be quite helpful
> for learning how to
> squeeze information from your database.  Lastly, if
> you are an R user, be
> sure to check out RdbiPgSQL, available via the
> BioConductor site, for
> interfacing R with Postgres.
> Sean

Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.

In response to


pgsql-novice by date

Next:From: Sean DavisDate: 2005-11-30 13:43:12
Subject: Re: Combinatorial problem
Previous:From: Sean DavisDate: 2005-11-30 11:46:03
Subject: Re: Combinatorial problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group