From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 20 Aug 2023 11:52:03 +0000 (+0200)
Subject: fix parameter use for ST_Project
X-Git-Tag: v4.3.0~21^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/7c79b07817a6e647113786dffbbfbfd9024fb64f

fix parameter use for ST_Project

Before postgis 3.4 ST_Project required a geography as input and seemed
to have implicitly converted to geography. Since 3.4 geometry input
is supported but leads to a completely different result.
---

diff --git a/lib-sql/functions/utils.sql b/lib-sql/functions/utils.sql
index f5be7b61..b2771ba1 100644
--- a/lib-sql/functions/utils.sql
+++ b/lib-sql/functions/utils.sql
@@ -273,8 +273,8 @@ BEGIN
   END IF;
 
   RETURN ST_Envelope(ST_Collect(
-                     ST_Project(geom, radius, 0.785398)::geometry,
-                     ST_Project(geom, radius, 3.9269908)::geometry));
+                     ST_Project(geom::geography, radius, 0.785398)::geometry,
+                     ST_Project(geom::geography, radius, 3.9269908)::geometry));
 END;
 $$
 LANGUAGE plpgsql IMMUTABLE;