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

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >CLOSE</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="CHECKPOINT"
  19 HREF="sql-checkpoint.html"><LINK
  20 REL="NEXT"
  21 TITLE="CLUSTER"
  22 HREF="sql-cluster.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-checkpoint.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-checkpoint.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-cluster.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="sql-cluster.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-CLOSE"
  93 ></A
  94 >CLOSE</H1
  95 ><DIV
  96 CLASS="REFNAMEDIV"
  97 ><A
  98 NAME="AEN35832"
  99 ></A
 100 ><H2
 101 >Name</H2
 102 >CLOSE&nbsp;--&nbsp;close a cursor</DIV
 103 ><A
 104 NAME="AEN35835"
 105 ></A
 106 ><DIV
 107 CLASS="REFSYNOPSISDIV"
 108 ><A
 109 NAME="AEN35837"
 110 ></A
 111 ><H2
 112 >Synopsis</H2
 113 ><PRE
 114 CLASS="SYNOPSIS"
 115 >CLOSE <VAR
 116 CLASS="REPLACEABLE"
 117 >name</VAR
 118 ></PRE
 119 ></DIV
 120 ><DIV
 121 CLASS="REFSECT1"
 122 ><A
 123 NAME="AEN35840"
 124 ></A
 125 ><H2
 126 >Description</H2
 127 ><P
 128 >   <TT
 129 CLASS="COMMAND"
 130 >CLOSE</TT
 131 > frees the resources associated with an open cursor.
 132    After the cursor is closed, no subsequent operations
 133    are allowed on it. A cursor should be closed when it is
 134    no longer needed.
 135   </P
 136 ><P
 137 >   Every non-holdable open cursor is implicitly closed when a
 138    transaction is terminated by <TT
 139 CLASS="COMMAND"
 140 >COMMIT</TT
 141 > or
 142    <TT
 143 CLASS="COMMAND"
 144 >ROLLBACK</TT
 145 >.  A holdable cursor is implicitly
 146    closed if the transaction that created it aborts via
 147    <TT
 148 CLASS="COMMAND"
 149 >ROLLBACK</TT
 150 >.  If the creating transaction successfully
 151    commits, the holdable
 152    cursor remains open until an explicit <TT
 153 CLASS="COMMAND"
 154 >CLOSE</TT
 155 > is
 156    executed, or the client disconnects.
 157   </P
 158 ></DIV
 159 ><DIV
 160 CLASS="REFSECT1"
 161 ><A
 162 NAME="AEN35849"
 163 ></A
 164 ><H2
 165 >Parameters</H2
 166 ><P
 167 ></P
 168 ><DIV
 169 CLASS="VARIABLELIST"
 170 ><DL
 171 ><DT
 172 ><VAR
 173 CLASS="REPLACEABLE"
 174 >name</VAR
 175 ></DT
 176 ><DD
 177 ><P
 178 >      The name of an open cursor to close.
 179      </P
 180 ></DD
 181 ></DL
 182 ></DIV
 183 ></DIV
 184 ><DIV
 185 CLASS="REFSECT1"
 186 ><A
 187 NAME="AEN35857"
 188 ></A
 189 ><H2
 190 >Notes</H2
 191 ><P
 192 >   <SPAN
 193 CLASS="PRODUCTNAME"
 194 >PostgreSQL</SPAN
 195 > does not have an explicit
 196    <TT
 197 CLASS="COMMAND"
 198 >OPEN</TT
 199 > cursor statement; a cursor is considered
 200    open when it is declared.  Use the <TT
 201 CLASS="COMMAND"
 202 >DECLARE</TT
 203 >
 204    statement to declare a cursor.
 205   </P
 206 ></DIV
 207 ><DIV
 208 CLASS="REFSECT1"
 209 ><A
 210 NAME="AEN35863"
 211 ></A
 212 ><H2
 213 >Examples</H2
 214 ><P
 215 >   Close the cursor <TT
 216 CLASS="LITERAL"
 217 >liahona</TT
 218 >:
 219 </P><PRE
 220 CLASS="PROGRAMLISTING"
 221 >CLOSE liahona;</PRE
 222 ><P>
 223   </P
 224 ></DIV
 225 ><DIV
 226 CLASS="REFSECT1"
 227 ><A
 228 NAME="AEN35868"
 229 ></A
 230 ><H2
 231 >Compatibility</H2
 232 ><P
 233 >   <TT
 234 CLASS="COMMAND"
 235 >CLOSE</TT
 236 > is fully conforming with the SQL standard.
 237   </P
 238 ></DIV
 239 ><DIV
 240 CLASS="NAVFOOTER"
 241 ><HR
 242 ALIGN="LEFT"
 243 WIDTH="100%"><TABLE
 244 SUMMARY="Footer navigation table"
 245 WIDTH="100%"
 246 BORDER="0"
 247 CELLPADDING="0"
 248 CELLSPACING="0"
 249 ><TR
 250 ><TD
 251 WIDTH="33%"
 252 ALIGN="left"
 253 VALIGN="top"
 254 ><A
 255 HREF="sql-checkpoint.html"
 256 ACCESSKEY="P"
 257 >Prev</A
 258 ></TD
 259 ><TD
 260 WIDTH="34%"
 261 ALIGN="center"
 262 VALIGN="top"
 263 ><A
 264 HREF="index.html"
 265 ACCESSKEY="H"
 266 >Home</A
 267 ></TD
 268 ><TD
 269 WIDTH="33%"
 270 ALIGN="right"
 271 VALIGN="top"
 272 ><A
 273 HREF="sql-cluster.html"
 274 ACCESSKEY="N"
 275 >Next</A
 276 ></TD
 277 ></TR
 278 ><TR
 279 ><TD
 280 WIDTH="33%"
 281 ALIGN="left"
 282 VALIGN="top"
 283 >CHECKPOINT</TD
 284 ><TD
 285 WIDTH="34%"
 286 ALIGN="center"
 287 VALIGN="top"
 288 ><A
 289 HREF="sql-commands.html"
 290 ACCESSKEY="U"
 291 >Up</A
 292 ></TD
 293 ><TD
 294 WIDTH="33%"
 295 ALIGN="right"
 296 VALIGN="top"
 297 >CLUSTER</TD
 298 ></TR
 299 ></TABLE
 300 ></DIV
 301 ></BODY
 302 ></HTML
 303 >