diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-02-15 05:05:03 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-02-15 05:05:03 +0000 |
| commit | eecbb33267642a2f6fcb2a2652f55412b333f4df (patch) | |
| tree | fa2338a89e80f03895c538d3a1ed71e09e4e9e62 /src | |
| parent | bfe553fb49f00ef74021ca044794f27c13511342 (diff) | |
| download | postgresql-eecbb33267642a2f6fcb2a2652f55412b333f4df.tar.gz postgresql-eecbb33267642a2f6fcb2a2652f55412b333f4df.zip | |
Add ORDER BY to a query on information_schema.views, to avoid possible
platform-specific result ordering. Per buildfarm results.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/xml.out | 3 | ||||
| -rw-r--r-- | src/test/regress/expected/xml_1.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/xml.sql | 3 |
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; |