Re: how the heck do I model this?

<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 Tue Dec 14 2004 - 00:44:23 CET