diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/xindex.sgml | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/xindex.sgml b/doc/src/sgml/xindex.sgml index 6a906291411..dcb5f9b6517 100644 --- a/doc/src/sgml/xindex.sgml +++ b/doc/src/sgml/xindex.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/xindex.sgml,v 1.23 2002/03/27 19:19:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/xindex.sgml,v 1.24 2002/04/17 20:57:56 tgl Exp $ PostgreSQL documentation --> @@ -280,10 +280,12 @@ SELECT oid FROM pg_am WHERE amname = 'btree'; <classname>pg_opclass</classname>: <programlisting> -INSERT INTO pg_opclass (opcamid, opcname, opcintype, opcdefault, opckeytype) +INSERT INTO pg_opclass (opcamid, opcname, opcnamespace, opcowner, opcintype, opcdefault, opckeytype) VALUES ( (SELECT oid FROM pg_am WHERE amname = 'btree'), 'complex_abs_ops', + (SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog'), + 1, -- UID of superuser is hardwired to 1 as of PG 7.3 (SELECT oid FROM pg_type WHERE typname = 'complex'), true, 0); @@ -292,9 +294,9 @@ SELECT oid, * FROM pg_opclass WHERE opcname = 'complex_abs_ops'; - oid | opcamid | opcname | opcintype | opcdefault | opckeytype ---------+---------+-----------------+-----------+------------+------------ - 277975 | 403 | complex_abs_ops | 277946 | t | 0 + oid | opcamid | opcname | opcnamespace | opcowner | opcintype | opcdefault | opckeytype +--------+---------+-----------------+--------------+----------+-----------+------------+------------ + 277975 | 403 | complex_abs_ops | 11 | 1 | 277946 | t | 0 (1 row) </programlisting> |