[SCM] PostGIS branch master updated. 3.5.0-400-g7fafa07fc

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  7fafa07fc293ec2a6326b8586fc0f747514ed9b2 (commit)
      from  a7da2ce57d27b54c3075755d969d21eabb31c871 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 7fafa07fc293ec2a6326b8586fc0f747514ed9b2
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Jun 14 05:21:30 2025 -0400

    Schema qualify geometry CAST in ST_GeomFromHash so can be used in materialized views

diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 998ae2a73..51fba0988 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -5400,7 +5400,7 @@ CREATE OR REPLACE FUNCTION ST_PointFromGeoHash(text, integer DEFAULT NULL)
 -- ST_GeomFromGeoHash(geohash text, precision integer)
 CREATE OR REPLACE FUNCTION ST_GeomFromGeoHash(text, integer DEFAULT NULL)
 	RETURNS geometry
-	AS $$ SELECT CAST(@extschema at .ST_Box2dFromGeoHash($1, $2) AS geometry); $$
+	AS $$ SELECT CAST(@extschema at .ST_Box2dFromGeoHash($1, $2) AS @extschema at .geometry); $$
 	LANGUAGE 'sql' IMMUTABLE PARALLEL SAFE
 	_COST_LOW;
 

-----------------------------------------------------------------------

Summary of changes:
 postgis/postgis.sql.in | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS