I have a table of devices with a column
I want to find devices within a bounding box with a query. Some bounding boxes are working, but others are not - it seems the bigger they get, at some point they stop working. To test this, I tried to search (almost) the whole world:
SELECT "device".* FROM devices AS "device" WHERE (ST_Intersects("device"."last_known_coordinates", ST_MakeEnvelope(179, -89, -179, 89)::geography))
This brings back none of the records, where I would expect all to be returned. Why aren't all records returned?