diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-03-11 19:40:24 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-03-11 19:40:24 +0000 |
| commit | 6261c75014c9948837d9d025493ef18b8f833f70 (patch) | |
| tree | f7d75ca8cfa6a093d0fde2f707ae48e90ced7771 /src/backend/executor/spi.c | |
| parent | e4704001ea4c3d63b53e8783859ff598ef2f69e5 (diff) | |
| download | postgresql-6261c75014c9948837d9d025493ef18b8f833f70.tar.gz postgresql-6261c75014c9948837d9d025493ef18b8f833f70.zip | |
Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n options
for FETCH and MOVE.
Diffstat (limited to 'src/backend/executor/spi.c')
| -rw-r--r-- | src/backend/executor/spi.c | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/backend/executor/spi.c b/src/backend/executor/spi.c index e1ccdf08f97..61eed9b4004 100644 --- a/src/backend/executor/spi.c +++ b/src/backend/executor/spi.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/executor/spi.c,v 1.87 2003/03/10 03:53:49 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/executor/spi.c,v 1.88 2003/03/11 19:40:22 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1349,8 +1349,11 @@ _SPI_cursor_operation(Portal portal, bool forward, int count, _SPI_current->tuptable = NULL; /* Run the cursor */ - _SPI_current->processed = DoPortalFetch(portal, forward, (long) count, - dest); + _SPI_current->processed = + DoPortalFetch(portal, + forward ? FETCH_FORWARD : FETCH_BACKWARD, + (long) count, + dest); if (dest == SPI && _SPI_checktuples()) elog(FATAL, "SPI_fetch: # of processed tuples check failed"); |