id summary reporter owner description type status priority milestone component version resolution keywords cc 2363 st_distance with an added Integer value is not working in 2.0 vbalent pramsey "I have two PostGIS environments (Windows Server and Linux) My Linux Version does not retrun records and throws no errors; I have built a simple SQL function in that 1) transforms my Lat Longs into State Plane US Feet WORKS 2) measure the distance between the two points and buffer it by 1 mile (5280) US Feet DOES NOT WORK However No Errors are thrown, just No Records are returned. SQL Statement SELECT P1.* FROM PART_1_CRIMES P1 WHERE P1.PART_I_CRIME IN ('MURDER','RAPE','ROBBERY','AGGRAVATED_ASSAULT','BURGLARY','LARCENY','MV_THEFT','MV_LARCENY') AND ST_DISTANCE(ST_TRANSFORM(ST_POINTFROMTEXT('POINT(-73.76545859999999 42.658618)', 4326), 2260),P1.GEOM)<=5280 ORDER BY P1.BEGINNING_DATE DESC LIMIT 1000; This exact same SQL statement works 100% as expected in this Version: PostgreSQL 9.1.7, compiled by Visual C++ build 1500, 32-bit POSTGIS=""1.5.5"" GEOS=""3.3.5-CAPI-1.7.5"" PROJ=""Rel. 4.6.1, 21 August 2008"" LIBXML=""2.7.8"" USE_STATS However not in this Version: PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit POSTGIS=""2.0.3 r11128"" GEOS=""3.3. 8-CAPI-1.7.8"" PROJ=""Rel. 4.8.0, 6 March 2012"" LIBXML=""2.7.6"" LIBJSON=""UNKNOWN"" TOPOLOGY Please advise? Regards Val 518-457-5905 " defect closed blocker PostGIS 2.0.4 postgis 2.0.x invalid vbalent