@@ -414,11 +414,19 @@ CREATE VIEW collview2 AS SELECT a, b FROM collate_test1 ORDER BY b COLLATE "C";
414414CREATE VIEW collview3 AS SELECT a, lower((x || x) COLLATE "C") FROM collate_test10;
415415SELECT table_name, view_definition FROM information_schema.views
416416 WHERE table_name LIKE 'collview%' ORDER BY 1;
417- table_name | view_definition
418- ------------+--------------------------------------------------------------------------------------------------------------------
419- collview1 | SELECT collate_test1.a, collate_test1.b FROM collate_test1 WHERE ((collate_test1.b COLLATE "C") >= 'bbc'::text);
420- collview2 | SELECT collate_test1.a, collate_test1.b FROM collate_test1 ORDER BY (collate_test1.b COLLATE "C");
421- collview3 | SELECT collate_test10.a, lower(((collate_test10.x || collate_test10.x) COLLATE "C")) AS lower FROM collate_test10;
417+ table_name | view_definition
418+ ------------+--------------------------------------------------------------------------
419+ collview1 | SELECT collate_test1.a, +
420+ | collate_test1.b +
421+ | FROM collate_test1 +
422+ | WHERE ((collate_test1.b COLLATE "C") >= 'bbc'::text);
423+ collview2 | SELECT collate_test1.a, +
424+ | collate_test1.b +
425+ | FROM collate_test1 +
426+ | ORDER BY (collate_test1.b COLLATE "C");
427+ collview3 | SELECT collate_test10.a, +
428+ | lower(((collate_test10.x || collate_test10.x) COLLATE "C")) AS lower+
429+ | FROM collate_test10;
422430(3 rows)
423431
424432-- collation propagation in various expression types