#include <cursor.hxx>
Inheritance diagram for pqxx::basic_cursor< ACCESS, UPDATE >:
Public Member Functions | |
basic_cursor (transaction_base *t, const PGSTD::string &query, const PGSTD::string &cname, ownershippolicy op=owned) | |
Create cursor based on given query. | |
basic_cursor (transaction_base *t, const PGSTD::string &cname, ownershippolicy op=owned) | |
Adopt existing SQL cursor. | |
virtual result | fetch (difference_type n) |
Fetch a number of rows from cursor. | |
virtual result | fetch (difference_type n, difference_type &d) |
virtual difference_type | move (difference_type n) |
Move cursor by given number of rows. | |
virtual difference_type | move (difference_type n, difference_type &d) |
|
Create cursor based on given query.
|
|
Adopt existing SQL cursor. Create a cursor object based on an existing SQL cursor. The name must be the exact name of that cursor (and unlike the name of a newly created cursor, will not be embellished for uniqueness).
|
|
|
|
Fetch a number of rows from cursor. This function can be used to fetch a given number of rows (by passing the desired number of rows as an argument), or all remaining rows (by passing cursor_base::all()), or fetch a given number of rows backwards from the current position (by passing the negative of the desired number), or all rows remaining behind the current position (by using cursor_base::backwards_all()). This function behaves slightly differently from the SQL FETCH command. Most notably, fetching zero rows does not move the cursor, and returns an empty result.
|
|
|
|
Move cursor by given number of rows.
|