[BioC] Is a number within a set of ranges?

[Daniel Brewer]

I have a table with a start and stop column which defines a set of
ranges.  I have another table with a list of genes with associated
position.  What I would like to do is subset the gene table so it only
contains genes whose position is within any of the ranges.  What is the
best way to do this?  The only way I can think of is to construct a long
list of conditions linked by ORs but I am sure there must be a better way.

Simple example:

Start	Stop
1	3
5	9
13	15

Gene	Position
1	14
2	4
3	10
4	6

I would like to get out:
Gene	Position
1	14
4	6

Any ideas?

Thanks

Dan

-- 
**************************************************************
Daniel Brewer, Ph.D.
Institute of Cancer Research
Email: daniel.brewer at icr.ac.uk
**************************************************************

The Institute of Cancer Research: Royal Cancer Hospital, a charitable Company Limited by Guarantee, Registered in England under Company No. 534147 with its Registered Office at 123 Old Brompton Road, London SW7 3RP.

This e-mail message is confidential and for use by the a...{{dropped:2}}