[postgis-users] Efficient 4D range query

Sandro Santilli strk at keybit.net
Wed May 20 03:56:04 PDT 2015


On Wed, May 20, 2015 at 01:29:43PM +0300, Hermano ... wrote:
> Thank you for you reply. I am doing this:
> 
> select * from myTable where point @ ST_MakeLine(ST_MakePoint(-72,42,0,100), ST_MakePoint(200,200,200,200))
> And one row is being returned, even though the point is outside the range. If I define the x and y ranges so the point is outsideits limits then no row is returned. But the z and m ranges are being completed ignored. The @ operator works only in 2D?

Yes. There's a single ND operator currently available: &&& (overlap)

--strk;


More information about the postgis-users mailing list