summaryrefslogtreecommitdiff
path: root/contrib/pg_trgm/expected/pg_trgm.out
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/pg_trgm/expected/pg_trgm.out')
-rw-r--r--contrib/pg_trgm/expected/pg_trgm.out8
1 files changed, 8 insertions, 0 deletions
diff --git a/contrib/pg_trgm/expected/pg_trgm.out b/contrib/pg_trgm/expected/pg_trgm.out
index 9bc55f1d0d..f646cbf90a 100644
--- a/contrib/pg_trgm/expected/pg_trgm.out
+++ b/contrib/pg_trgm/expected/pg_trgm.out
@@ -1,4 +1,12 @@
CREATE EXTENSION pg_trgm;
+-- Check whether any of our opclasses fail amvalidate
+SELECT amname, opcname
+FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
+WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid);
+ amname | opcname
+--------+---------
+(0 rows)
+
select show_trgm('');
show_trgm
-----------