Hi, I am using Postgres 9.3 and have a table with geometry columns: startloc geometry(Point), endloc geometry(Point),
When I run a query that crosses the date line boundary, I'm getting incorrect results. Example: SELECT * from od1.trip_v1_partitioned where startts>=TIMESTAMP '2015-02-16T20:00:00.000Z'and startts<TIMESTAMP '2015-02-17T20:00:00.000Z'and endts<TIMESTAMP '2015-02-17T20:00:00.000Z' and ST_intersects(startloc, ST_MakeValid(ST_GeomFromText('MULTIPOLYGON(((179.64844 67.73477,-155.03906 67.60118,-161.19141 61.8462,179.64844 67.73477)))'))) Would I need to change how my columns are stored (this would require a big migration), or is it possible to adjust my query to handle this correctly? Thanks, Trang
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users