3
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
4
<title>SPI_cursor_move</title>
5
<link rel="stylesheet" href="stylesheet.css" type="text/css">
6
<link rev="made" href="pgsql-docs@postgresql.org">
7
<meta name="generator" content="DocBook XSL Stylesheets V1.64.1">
8
<link rel="home" href="index.html" title="PostgreSQL 8.0.0beta5 Documentation">
9
<link rel="up" href="spi.html#spi-interface" title="39.1.�Interface Functions">
10
<link rel="previous" href="spi-spi-cursor-fetch.html" title="SPI_cursor_fetch">
11
<link rel="next" href="spi-spi-cursor-close.html" title="SPI_cursor_close">
13
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="refentry" lang="en">
14
<a name="spi-spi-cursor-move"></a><div class="titlepage">
18
<div class="refnamediv">
20
<p>SPI_cursor_move — move a cursor</p>
22
<a name="id2657498"></a><div class="refsynopsisdiv">
24
<pre class="synopsis">void SPI_cursor_move(Portal <i class="parameter"><tt>portal</tt></i>, bool <i class="parameter"><tt>forward</tt></i>, int <i class="parameter"><tt>count</tt></i>)</pre>
26
<div class="refsect1" lang="en">
27
<a name="id2657528"></a><h2>Description</h2>
28
<p> <tt class="function">SPI_cursor_move</tt> skips over some number of rows
29
in a cursor. This is equivalent to the SQL command
30
<tt class="command">MOVE</tt>.
33
<div class="refsect1" lang="en">
34
<a name="id2657547"></a><h2>Arguments</h2>
35
<div class="variablelist"><dl>
36
<dt><span class="term"><tt class="literal">Portal <i class="parameter"><tt>portal</tt></i></tt></span></dt>
37
<dd><p> portal containing the cursor
39
<dt><span class="term"><tt class="literal">bool <i class="parameter"><tt>forward</tt></i></tt></span></dt>
40
<dd><p> true for move forward, false for move backward
42
<dt><span class="term"><tt class="literal">int <i class="parameter"><tt>count</tt></i></tt></span></dt>
43
<dd><p> maximum number of rows to move