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....
On Wed, Apr 25, 2012 at 9:52 AM, Alvaro Tejero Cantero <alv...@minin.es>wrote: > Hello, > > I am interested in using some of the spatial operators to implement > the interval algebra operations [1] in one dimension. > > My application is tagging of intervals in neurophysiological > recordings, a little bit similar to what people do in genomics. > > I would like to know if it is possible, and whether PostGIS is also > optimized for this scenario. A typical query is to retrieve all > intervals of type A that are enclosed in intervals of type B. > > A few quick queries didn't return anything, and what I found about the > INTERVAL datatype in Postgres[2] didn't fit our scenario so well, > because they are using DATETIMEs and we need to use integer timestamps > (4-byte integers are enough), as we are sampling time at 20000Hz. > > Any comments are appreciated. > > Cheers, > > -รก. > > [1] http://en.wikipedia.org/wiki/Allen's_interval_algebra > [2] > http://wiki.postgresql.org/wiki/Working_with_Dates_and_Times_in_PostgreSQL > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- ************************************ David William Bitner
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
