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