Выборка записей из курсора
Листинг 7.43. Выборка записей из курсора
booktown=# FETCH 4 FROM all_books;
Id | title | authored | suojectjd
7808 | The Shining | 4156 | 9
4513 | Dune 1 1866 | 15
4267 I 2001: A Space Odyssey | 2001 | 15
1608 I The Cat in the Hat j 1809 2
(4 rows)
booktown=# FETCH NEXT FROM all_books;
id | title | authorjd | subjectjd
1590 Bartholomew and the Oobleck 1809 2
(1 row)
booktown=# FETCH PRIOR FROM all_books:
id | title | authorjd subjectjd
1608 | The Cat in the Hat | 1809 | 2
(1 row)