<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Thank you for you reply. I am doing this:<br><br><div>select * from myTable where point @ ST_MakeLine(ST_MakePoint(-72,42,0,100), ST_MakePoint(200,200,200,200))</div><div><br></div><div>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 outside</div><div>its limits then no row is returned. But the z and m ranges are being completed ignored. The @ operator works only in 2D?</div><div><br></div><div><br></div><br><div>> Date: Wed, 20 May 2015 11:02:50 +0200<br>> From: strk@keybit.net<br>> To: postgis-users@lists.osgeo.org<br>> Subject: Re: [postgis-users] Efficient 4D range query<br>> <br>> On Wed, May 20, 2015 at 02:18:55AM +0300, Hermano ... wrote:<br>> > Hello<br>> > How one can express a 4D range query in Postgis? I would like to know what 4d points lie within a hypercube. This is my table: CREATE TABLE myTable<br>> > (<br>> > point geometry,<br>> > attrib double precision,<br>> > CONSTRAINT ge_idx PRIMARY KEY (point)<br>> > );<br>> > This is how I inserted the data points: insert into myTable (point) values (ST_MakePoint(-71.10, 42.31, 12.43, 54.3));<br>> > <br>> > It's trivial to specify a 2D bounding box, but I couldn't find a way to do the same in 4D. <br>> <br>> The simplest way to specify ranges in N-D is to write them as linestrings:<br>> <br>> ST_MakeLine(<br>> ST_MakePoint(xmin,ymin,zmin,mmin),<br>> ST_MakePoint(xmax,ymax,zmax,mmax)<br>> )<br>> <br>> --strk;<br>> <br>> () Free GIS & Flash consultant/developer<br>> /\ http://strk.keybit.net/services.html<br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@lists.osgeo.org<br>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></div> </div></body>
</html>