Re: Combinatorial problem

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/