Re: how the heck do I model this?

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 13 Dec 2004 15:44:23 -0800
Message-ID: <y_pvd.30$wM2.24@news.oracle.com>

<carol_marra_at_msn.com> wrote in message
news:1102971025.583612.91640_at_c13g2000cwb.googlegroups.com...
> Alan -- By "runtime" I mean the time when some application will
> query this table, providing a source_id value and n key/value pairs,
> and needing to get back a site_datatype_id and interval. '

Could you please coherently formulate the problem by eliminating all irrelevant details? A clearly formulated problem looks like this. Given a set of intervals

table intervals (

head integer,
tail integer
)

find all the intervals that cover point x=100:

select * from intervals
where 100 between head and tail Received on Mon Dec 13 2004 - 17:44:23 CST