On Sun, 21 Sep 2008, "Anton Belyaev" <[EMAIL PROTECTED]> writes: > SELECT * FROM towns where alt1 <= alt <= alt2 AND long1 <= long <= > long2 ORDER BY population LIMIT 10;
You're absolutely on the wrong path. Don't try to implement a logic, that has been implemented by PostgreSQL in the most possibly efficient way in its bounds. See geographic data types[1] (e.g. box) and geographic functions[2] (e.g. @> a.k.a contains). Regards. [1] http://www.postgresql.org/docs/current/interactive/datatype-geometric.html [2] http://www.postgresql.org/docs/current/interactive/functions-geometry.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
