I686LINUX/util/I686LINUX/doc/postgresql/html/sql-alteropclass.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >ALTER OPERATOR CLASS</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="SQL Commands"
  16 HREF="sql-commands.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="ALTER LANGUAGE"
  19 HREF="sql-alterlanguage.html"><LINK
  20 REL="NEXT"
  21 TITLE="ALTER SCHEMA"
  22 HREF="sql-alterschema.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="REFENTRY"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="sql-alterlanguage.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="sql-alterlanguage.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="sql-alterschema.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="sql-alterschema.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><H1
  91 ><A
  92 NAME="SQL-ALTEROPCLASS"
  93 ></A
  94 >ALTER OPERATOR CLASS</H1
  95 ><DIV
  96 CLASS="REFNAMEDIV"
  97 ><A
  98 NAME="AEN35030"
  99 ></A
 100 ><H2
 101 >Name</H2
 102 >ALTER OPERATOR CLASS&nbsp;--&nbsp;change the definition of an operator class</DIV
 103 ><A
 104 NAME="AEN35033"
 105 ></A
 106 ><DIV
 107 CLASS="REFSYNOPSISDIV"
 108 ><A
 109 NAME="AEN35035"
 110 ></A
 111 ><H2
 112 >Synopsis</H2
 113 ><PRE
 114 CLASS="SYNOPSIS"
 115 >ALTER OPERATOR CLASS <VAR
 116 CLASS="REPLACEABLE"
 117 >name</VAR
 118 > USING <VAR
 119 CLASS="REPLACEABLE"
 120 >index_method</VAR
 121 > RENAME TO <VAR
 122 CLASS="REPLACEABLE"
 123 >newname</VAR
 124 ></PRE
 125 ></DIV
 126 ><DIV
 127 CLASS="REFSECT1"
 128 ><A
 129 NAME="AEN35040"
 130 ></A
 131 ><H2
 132 >Description</H2
 133 ><P
 134 >   <TT
 135 CLASS="COMMAND"
 136 >ALTER OPERATOR CLASS</TT
 137 > changes the definition of
 138    an operator class.  The only functionality is to rename the
 139    operator class.
 140   </P
 141 ></DIV
 142 ><DIV
 143 CLASS="REFSECT1"
 144 ><A
 145 NAME="AEN35044"
 146 ></A
 147 ><H2
 148 >Parameters</H2
 149 ><P
 150 ></P
 151 ><DIV
 152 CLASS="VARIABLELIST"
 153 ><DL
 154 ><DT
 155 ><VAR
 156 CLASS="REPLACEABLE"
 157 >name</VAR
 158 ></DT
 159 ><DD
 160 ><P
 161 >      The name (optionally schema-qualified) of an existing operator
 162       class.
 163      </P
 164 ></DD
 165 ><DT
 166 ><VAR
 167 CLASS="REPLACEABLE"
 168 >index_method</VAR
 169 ></DT
 170 ><DD
 171 ><P
 172 >      The name of the index method this operator class is for.
 173      </P
 174 ></DD
 175 ><DT
 176 ><VAR
 177 CLASS="REPLACEABLE"
 178 >newname</VAR
 179 ></DT
 180 ><DD
 181 ><P
 182 >      The new name of the operator class.
 183      </P
 184 ></DD
 185 ></DL
 186 ></DIV
 187 ></DIV
 188 ><DIV
 189 CLASS="REFSECT1"
 190 ><A
 191 NAME="AEN35062"
 192 ></A
 193 ><H2
 194 >Compatibility</H2
 195 ><P
 196 >   There is no <TT
 197 CLASS="COMMAND"
 198 >ALTER OPERATOR CLASS</TT
 199 > statement in
 200    the SQL standard.
 201   </P
 202 ></DIV
 203 ><DIV
 204 CLASS="REFSECT1"
 205 ><A
 206 NAME="AEN35066"
 207 ></A
 208 ><H2
 209 >See Also</H2
 210 ><A
 211 HREF="sql-createopclass.html"
 212 ><I
 213 >CREATE OPERATOR CLASS</I
 214 ></A
 215 >, <A
 216 HREF="sql-dropopclass.html"
 217 ><I
 218 >DROP OPERATOR CLASS</I
 219 ></A
 220 ></DIV
 221 ><DIV
 222 CLASS="NAVFOOTER"
 223 ><HR
 224 ALIGN="LEFT"
 225 WIDTH="100%"><TABLE
 226 SUMMARY="Footer navigation table"
 227 WIDTH="100%"
 228 BORDER="0"
 229 CELLPADDING="0"
 230 CELLSPACING="0"
 231 ><TR
 232 ><TD
 233 WIDTH="33%"
 234 ALIGN="left"
 235 VALIGN="top"
 236 ><A
 237 HREF="sql-alterlanguage.html"
 238 ACCESSKEY="P"
 239 >Prev</A
 240 ></TD
 241 ><TD
 242 WIDTH="34%"
 243 ALIGN="center"
 244 VALIGN="top"
 245 ><A
 246 HREF="index.html"
 247 ACCESSKEY="H"
 248 >Home</A
 249 ></TD
 250 ><TD
 251 WIDTH="33%"
 252 ALIGN="right"
 253 VALIGN="top"
 254 ><A
 255 HREF="sql-alterschema.html"
 256 ACCESSKEY="N"
 257 >Next</A
 258 ></TD
 259 ></TR
 260 ><TR
 261 ><TD
 262 WIDTH="33%"
 263 ALIGN="left"
 264 VALIGN="top"
 265 >ALTER LANGUAGE</TD
 266 ><TD
 267 WIDTH="34%"
 268 ALIGN="center"
 269 VALIGN="top"
 270 ><A
 271 HREF="sql-commands.html"
 272 ACCESSKEY="U"
 273 >Up</A
 274 ></TD
 275 ><TD
 276 WIDTH="33%"
 277 ALIGN="right"
 278 VALIGN="top"
 279 >ALTER SCHEMA</TD
 280 ></TR
 281 ></TABLE
 282 ></DIV
 283 ></BODY
 284 ></HTML
 285 >