move man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

MOVE()				 SQL Commands				MOVE()

NAME
       MOVE - Moves cursor position

SYNOPSIS
       MOVE [ direction ] [ count ]
	   { IN | FROM } cursor

DESCRIPTION
       MOVE  allows a user to move cursor position a specified number of rows.
       MOVE works like the FETCH command, but only positions  the  cursor  and
       does not return rows.

       Refer to FETCH [fetch(l)] for details on syntax and usage.

   NOTES
       MOVE is a Postgres language extension.

       Refer  to FETCH [fetch(l)] for a description of valid arguments.	 Refer
       to DECLARE [declare(l)] to define a cursor.  Refer to BEGIN [begin(l)],
       COMMIT  [commit(l)], and ROLLBACK [rollback(l)] for further information
       about transactions.

USAGE
       Set up and use a cursor:

       BEGIN WORK;
       DECLARE liahona CURSOR  FOR SELECT * FROM films;
       -- Skip first 5 rows:
       MOVE FORWARD 5 IN liahona;
       MOVE
       -- Fetch 6th row in the cursor liahona:
       FETCH 1 IN liahona;
       FETCH

	code  | title  | did | date_prod | kind	  | len
       -------+--------+-----+-----------+--------+-------
	P_303 | 48 Hrs | 103 | 1982-10-22| Action | 01:37
       (1 row)
       -- close the cursor liahona and commit work:
       CLOSE liahona;
       COMMIT WORK;

COMPATIBILITY
   SQL92
       There is no SQL92 MOVE statement.  Instead, SQL92 allows one  to	 FETCH
       rows  from an absolute cursor position, implicitly moving the cursor to
       the correct position.

SQL - Language Statements	 29 March 2001				MOVE()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net