David, Mike, thank you very much for this spot-on information!
I have two follow-up questions: 1/ is there an estimated release date for pg 9.2? (in its stead: are Postgres pre-release versions usually 'stable enough' - I am in an explorative setting, rock-solid stability is not yet needed). 2/ do these functions work with sets of intervals? I found an older post about an extension that seems to care for that http://scottrbailey.wordpress.com/2009/10/06/timespan_sets/ and I am concerned about how to do that efficiently (i.e. without a double loop on A intervals and B intervals). Thanks again, -รก. On Wed, Apr 25, 2012 at 22:43, Mike Toews <mwto...@gmail.com> wrote: > On 26 April 2012 07:41, David William Bitner <bit...@gyttja.org> wrote: > > If you follow PostgreSQL development, you can see that 9.2 is bringing a > > whole suite of range data types for dealing with one dimensional > intervals > > with the same expressivity as PostGIS. Not there yet, but coming soon.... > > Yup, I'll certainly agree with David's suggestion of the new range > type for 9.2. You can define integer ranges using int4range. The range > type shares some of the same DB technology as PostGIS, such as GiST > indices, so it is sort-of a 1D version of PostGIS. > > A really good article describing the upcoming range type is at: > http://www.depesz.com/2011/11/07/waiting-for-9-2-range-data-types/ > > -Mike > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
