xo::db::require proc index (public)
xo::db::requireindex [ -table table ] [ -col col ] \ [ -expression expression ] [ -expression_name expression_name ] \ [ -using using ] [ -unique unique ]
Defined in /var/www/openacs/packages/xotcl-core/tcl/05-db-procs.tcl
Create the named-by-convention index if it is missing. Supply either a column list or an expression.
- Switches:
- -table (optional)
- Table to index.
- -col (optional)
- Comma-separated column list.
- -expression (optional)
- SQL expression to index.
- -expression_name (optional)
- Optional name component for an expression index.
- -using (optional)
- Optional index access method for PostgreSQL.
- -unique (optional, defaults to
"false")- Whether to create a unique index.
- Testcases:
- xotcl_core_tutorial_2
![[i]](/resources/acs-subsite/ZoomIn16.gif)