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: | 20051130132638.85584.qmail@web31602.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
thanks
>
> 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.
http://music.yahoo.com/unlimited/
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-11-30 13:43:12 | Re: Combinatorial problem |
Previous Message | Sean Davis | 2005-11-30 11:46:03 | Re: Combinatorial problem |