X-Git-Url: https://granicus.if.org/sourcecode?a=blobdiff_plain;f=doc%2Fsrc%2Fsgml%2Fref%2Ffetch.sgml;h=b08ad4a191e8141314d967a95163688448e87f14;hb=33f0108df8a79cdb6dbf91f7eb4329143c0730d8;hp=fae7ab5ba246035a08ff26b240d2e802c271ee70;hpb=a0fa0117a5ad728b6f85a39cc52006736f54f90e;p=postgresql diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index fae7ab5ba2..b08ad4a191 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -1,5 +1,5 @@ @@ -89,7 +89,7 @@ FETCH [ FORWARD | BACKWARD | RELATIVE ] [ # A signed integer that specifies how many rows to fetch. Note that a negative integer is equivalent to changing the sense of - FORWARD and BACKWARD. + FORWARD and BACKWARD. Zero re-fetches the current row. @@ -180,30 +180,6 @@ WARNING: FETCH/ABSOLUTE not supported, using RELATIVE - - -ERROR: FETCH/RELATIVE at current position is not supported - - - - SQL92 allows one to repetitively retrieve the cursor - at its current position using the syntax - -FETCH RELATIVE 0 FROM cursor. - - - - - PostgreSQL does not currently support - this notion; in fact the value zero is reserved to indicate that - all rows should be retrieved and is equivalent to specifying the ALL keyword. - If the RELATIVE keyword has been used, PostgreSQL - assumes that the user intended SQL92 behavior - and returns this error message. - - - -