| Server IP : 109.234.162.214 / Your IP : 216.73.216.34 Web Server : Apache System : Linux servd162214.srv.odns.fr 4.18.0-372.26.1.lve.1.el8.x86_64 #1 SMP Fri Sep 16 14:08:19 EDT 2022 x86_64 User : carpe ( 1178) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /opt/alt/postgresql11/usr/share/man/man3/ |
Upload File : |
'\" t .\" Title: SPI_cursor_fetch .\" Author: The PostgreSQL Global Development Group .\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/> .\" Date: 2017-11-06 .\" Manual: PostgreSQL 9.2.24 Documentation .\" Source: PostgreSQL 9.2.24 .\" Language: English .\" .TH "SPI_CURSOR_FETCH" "3" "2017-11-06" "PostgreSQL 9.2.24" "PostgreSQL 9.2.24 Documentation" .\" ----------------------------------------------------------------- .\" * Define some portability stuff .\" ----------------------------------------------------------------- .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .\" http://bugs.debian.org/507673 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ .ie \n(.g .ds Aq \(aq .el .ds Aq ' .\" ----------------------------------------------------------------- .\" * set default formatting .\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .\" ----------------------------------------------------------------- .\" * MAIN CONTENT STARTS HERE * .\" ----------------------------------------------------------------- .SH "NAME" SPI_cursor_fetch \- fetch some rows from a cursor .\" SPI_cursor_fetch .SH "SYNOPSIS" .sp .nf void SPI_cursor_fetch(Portal \fIportal\fR, bool \fIforward\fR, long \fIcount\fR) .fi .SH "DESCRIPTION" .PP \fBSPI_cursor_fetch\fR fetches some rows from a cursor\&. This is equivalent to a subset of the SQL command \fBFETCH\fR (see \fBSPI_scroll_cursor_fetch\fR for more functionality)\&. .SH "ARGUMENTS" .PP Portal \fIportal\fR .RS 4 portal containing the cursor .RE .PP bool \fIforward\fR .RS 4 true for fetch forward, false for fetch backward .RE .PP long \fIcount\fR .RS 4 maximum number of rows to fetch .RE .SH "RETURN VALUE" .PP \fISPI_processed\fR and \fISPI_tuptable\fR are set as in \fBSPI_execute\fR if successful\&. .SH "NOTES" .PP Fetching backward may fail if the cursor\*(Aqs plan was not created with the CURSOR_OPT_SCROLL option\&.