aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/xml.out3
-rw-r--r--src/test/regress/expected/xml_1.out3
-rw-r--r--src/test/regress/sql/xml.sql3
3 files changed, 6 insertions, 3 deletions
diff --git a/src/test/regress/expected/xml.out b/src/test/regress/expected/xml.out
index 6d79a4166e7..97c30600e84 100644
--- a/src/test/regress/expected/xml.out
+++ b/src/test/regress/expected/xml.out
@@ -386,7 +386,8 @@ CREATE VIEW xmlview6 AS SELECT xmlpi(name foo, 'bar');
CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version no value, standalone yes);
CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));
CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);
-SELECT table_name, view_definition FROM information_schema.views WHERE table_name LIKE 'xmlview%';
+SELECT table_name, view_definition FROM information_schema.views
+ WHERE table_name LIKE 'xmlview%' ORDER BY 1;
table_name | view_definition
------------+--------------------------------------------------------------------------------------------------------------------------------
xmlview1 | SELECT xmlcomment('test'::text) AS xmlcomment;
diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out
index 899ed4cd266..95b9d736151 100644
--- a/src/test/regress/expected/xml_1.out
+++ b/src/test/regress/expected/xml_1.out
@@ -189,7 +189,8 @@ CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));
ERROR: no XML support in this installation
CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);
ERROR: no XML support in this installation
-SELECT table_name, view_definition FROM information_schema.views WHERE table_name LIKE 'xmlview%';
+SELECT table_name, view_definition FROM information_schema.views
+ WHERE table_name LIKE 'xmlview%' ORDER BY 1;
table_name | view_definition
------------+-------------------------------------------------------------------------------
xmlview1 | SELECT xmlcomment('test'::text) AS xmlcomment;
diff --git a/src/test/regress/sql/xml.sql b/src/test/regress/sql/xml.sql
index 2f919fb42a0..6ed9d8c47a2 100644
--- a/src/test/regress/sql/xml.sql
+++ b/src/test/regress/sql/xml.sql
@@ -142,4 +142,5 @@ CREATE VIEW xmlview7 AS SELECT xmlroot(xml '<foo/>', version no value, standalon
CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));
CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);
-SELECT table_name, view_definition FROM information_schema.views WHERE table_name LIKE 'xmlview%';
+SELECT table_name, view_definition FROM information_schema.views
+ WHERE table_name LIKE 'xmlview%' ORDER BY 1;