[postgis-users] Using PosGIS in one dimension

[Alvaro Tejero Cantero]

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 <mwtoews at gmail.com> wrote:

> On 26 April 2012 07:41, David William Bitner <bitner at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/2eab1d7b/attachment.html>