Ticket #269 (closed defect: fixed)
Geography->Geometry cast should be explicit
|Reported by:||mcayland||Owned by:||pramsey|
Description (last modified by robe) (diff)
We really shouldn't be allowing people to use functions designated for geometry with geography data type without forcing them to explicitly cast to geometry.
This is bad:
trunk=# explain analyze select count(*) from cities where the_geog && ST_SetSRID(ST_GeographyFromText('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'), 4326);
ERROR: operator is not unique: geography && geometry LINE 1: ...nalyze select count(*) from cities where the_geog && ST_SetS...