From 7679207053c965a8c656ee4b79bcf92c6ac9e854 Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Mon, 23 Feb 2015 18:19:10 +0000
Subject: [PATCH] Do not require XML support in PostgreSQL for testing purposes

git-svn-id: http://svn.osgeo.org/postgis/trunk@13271 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/regress_index.sql | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

diff --git a/regress/regress_index.sql b/regress/regress_index.sql
index 22e141758..5397dc345 100644
--- a/regress/regress_index.sql
+++ b/regress/regress_index.sql
@@ -7,14 +7,10 @@ CREATE FUNCTION qnodes(q text) RETURNS text
 LANGUAGE 'plpgsql' AS
 $$
 DECLARE
-  exp XML;
+  exp TEXT;
 BEGIN
-  EXECUTE 'EXPLAIN (FORMAT XML, VERBOSE) ' || q INTO STRICT exp;
-  RETURN array_to_string(
-    xpath('//x:Node-Type/text()', exp,
-          ARRAY[ARRAY['x', 'http://www.postgresql.org/2009/explain']]),
-    ','
-  );
+  EXECUTE 'EXPLAIN ' || q INTO exp;
+  RETURN (regexp_matches(exp, ' *(.*Scan)'))[1];
 END;
 $$;
 
-- 
2.50.1