On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote: > GiST can also be useful if you have to query in multiple dimensions, > which can occur outside the normal case of geometry. Best example I > know of is a table containing duration information in the form of > start_time and end_time. Trying to query for what events happened on > 5/28/2005 will generally be much cheaper with a GiST index than a b- > tree. Are you referring to queries with ... where some_timestamp between some_start and some_end ... or ... where some_timestamp > some_start and some_timestamp < some_end ... ? Thanks, Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
