diff options
Diffstat (limited to 'src/tutorial/syscat.source')
| -rw-r--r-- | src/tutorial/syscat.source | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/src/tutorial/syscat.source b/src/tutorial/syscat.source index 50bd2e31a66..f6460d3fc07 100644 --- a/src/tutorial/syscat.source +++ b/src/tutorial/syscat.source @@ -7,7 +7,7 @@ -- Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group -- Portions Copyright (c) 1994, Regents of the University of California -- --- $PostgreSQL: pgsql/src/tutorial/syscat.source,v 1.16 2006/03/05 15:59:11 momjian Exp $ +-- $PostgreSQL: pgsql/src/tutorial/syscat.source,v 1.17 2006/12/23 00:43:13 tgl Exp $ -- --------------------------------------------------------------------------- @@ -165,18 +165,18 @@ SELECT n.nspname, p.proname, format_type(t.oid, null) as typname -- --- lists all the operator classes that can be used with each access method --- as well as the operators that cn be used with the respective operator --- classes +-- lists all the operator families that can be used with each access method +-- as well as the operators that can be used with the respective operator +-- families -- -SELECT n.nspname, am.amname, opc.opcname, opr.oprname - FROM pg_namespace n, pg_am am, pg_opclass opc, +SELECT am.amname, n.nspname, opf.opfname, opr.oprname + FROM pg_namespace n, pg_am am, pg_opfamily opf, pg_amop amop, pg_operator opr - WHERE opc.opcnamespace = n.oid - and opc.opcamid = am.oid - and amop.amopclaid = opc.oid + WHERE opf.opfnamespace = n.oid + and opf.opfmethod = am.oid + and amop.amopfamily = opf.oid and amop.amopopr = opr.oid - ORDER BY nspname, amname, opcname, oprname; + ORDER BY nspname, amname, opfname, oprname; -- -- Reset the search path |