From 44b3230e821e7a0cc4e9438d1c27305d533edacc Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 8 Oct 2017 22:00:57 -0400 Subject: Use lower-case SGML attribute values for DocBook XML compatibility --- doc/src/sgml/ref/fetch.sgml | 64 ++++++++++++++++++++++----------------------- 1 file changed, 32 insertions(+), 32 deletions(-) (limited to 'doc/src/sgml/ref/fetch.sgml') diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index 24c8c491569..7651dcd0f82 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -27,23 +27,23 @@ PostgreSQL documentation -FETCH [ direction [ FROM | IN ] ] cursor_name +FETCH [ direction [ FROM | IN ] ] cursor_name -where direction can be empty or one of: +where direction can be empty or one of: NEXT PRIOR FIRST LAST - ABSOLUTE count - RELATIVE count - count + ABSOLUTE count + RELATIVE count + count ALL FORWARD - FORWARD count + FORWARD count FORWARD ALL BACKWARD - BACKWARD count + BACKWARD count BACKWARD ALL @@ -82,7 +82,7 @@ FETCH [ direction [ FROM | IN ] ] < retrieve the indicated number of rows moving in the forward or backward direction, leaving the cursor positioned on the last-returned row (or after/before all rows, if the count exceeds the number of rows + class="parameter">count exceeds the number of rows available). @@ -109,9 +109,9 @@ FETCH [ direction [ FROM | IN ] ] < - direction + direction - direction defines + direction defines the fetch direction and number of rows to fetch. It can be one of the following: @@ -121,7 +121,7 @@ FETCH [ direction [ FROM | IN ] ] < Fetch the next row. This is the default if direction is omitted. + class="parameter">direction is omitted. @@ -154,17 +154,17 @@ FETCH [ direction [ FROM | IN ] ] < - ABSOLUTE count + ABSOLUTE count Fetch the count'th row of the query, + class="parameter">count'th row of the query, or the abs(count)'th row from + class="parameter">count)'th row from the end if count is negative. Position + class="parameter">count is negative. Position before first row or after last row if count is out of range; in + class="parameter">count is out of range; in particular, ABSOLUTE 0 positions before the first row. @@ -172,14 +172,14 @@ FETCH [ direction [ FROM | IN ] ] < - RELATIVE count + RELATIVE count Fetch the count'th succeeding row, or + class="parameter">count'th succeeding row, or the abs(count)'th prior - row if count is + class="parameter">count)'th prior + row if count is negative. RELATIVE 0 re-fetches the current row, if any. @@ -187,13 +187,13 @@ FETCH [ direction [ FROM | IN ] ] < - count + count Fetch the next count rows (same as + class="parameter">count rows (same as FORWARD count). + class="parameter">count). @@ -217,11 +217,11 @@ FETCH [ direction [ FROM | IN ] ] < - FORWARD count + FORWARD count Fetch the next count rows. + class="parameter">count rows. FORWARD 0 re-fetches the current row. @@ -246,11 +246,11 @@ FETCH [ direction [ FROM | IN ] ] < - BACKWARD count + BACKWARD count Fetch the prior count rows (scanning + class="parameter">count rows (scanning backwards). BACKWARD 0 re-fetches the current row. @@ -270,20 +270,20 @@ FETCH [ direction [ FROM | IN ] ] < - count + count - count is a + count is a possibly-signed integer constant, determining the location or number of rows to fetch. For FORWARD and BACKWARD cases, specifying a negative count is equivalent to changing + class="parameter">count is equivalent to changing the sense of FORWARD and BACKWARD. - cursor_name + cursor_name An open cursor's name. @@ -394,7 +394,7 @@ COMMIT WORK; The FETCH forms involving FORWARD and BACKWARD, as well as the forms FETCH count and FETCH + class="parameter">count and FETCH ALL, in which FORWARD is implicit, are PostgreSQL extensions. -- cgit v1.2.3