Просмотр исходного текста страницы PostgreSQL/Cursor/FETCH FORWARD

==Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows==



   
  <!-- start source code -->
   
    <source lang="sql">
postgres=# CREATE TABLE "publishers" (
postgres(#      "id" integer NOT NULL,
postgres(#      "name" text,
postgres(#      "address" text,
postgres(#      Constraint "publishers_pkey" Primary Key ("id")
postgres(# );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "publishers_pkey" for table "publishers"
CREATE TABLE
postgres=#
postgres=#
postgres=# insert into publishers values(150, "Can Press",  "29 Ave. Toronto, ON");
INSERT 0 1
postgres=# insert into publishers values(91,  "Henry Inc.", "115 Street New York, NY");
INSERT 0 1
postgres=# insert into publishers values(113, "O Inc.",     "101 St, Sebastopol, CA");
INSERT 0 1
postgres=# insert into publishers values(62,  "W Pubs",     "1515, New York");
INSERT 0 1
postgres=# insert into publishers values(105, "N Press",    "19 W, New York");
INSERT 0 1
postgres=# insert into publishers values(99,  "A Inc",      "375 St, New York");
INSERT 0 1
postgres=# insert into publishers values(101, "Z Inc",      "375 Ave, New York");
INSERT 0 1
postgres=# insert into publishers values(163, "M Press",    "PO Box 1215");
INSERT 0 1
postgres=# insert into publishers values(171, "B",          "16 W. 18th St. New York");
INSERT 0 1
postgres=# insert into publishers values(102, "P Inc",      "375 Hudson St, New York");
INSERT 0 1
postgres=# insert into publishers values(75,  "D Inc",      "1540 Broadway, New York");
INSERT 0 1
postgres=# insert into publishers values(65,  "H Pubs",     "10 E 53rd St, New York");
INSERT 0 1
postgres=# insert into publishers values(59,  "R Inc",      "1540 Broadway, New York");
INSERT 0 1
postgres=#
postgres=# select * from publishers;
 id  |    name    |         address
-----+------------+-------------------------
 150 | Can Press  | 29 Ave. Toronto, ON
  91 | Henry Inc. | 115 Street New York, NY
 113 | O Inc.     | 101 St, Sebastopol, CA
  62 | W Pubs     | 1515, New York
 105 | N Press    | 19 W, New York
  99 | A Inc      | 375 St, New York
 101 | Z Inc      | 375 Ave, New York
 163 | M Press    | PO Box 1215
 171 | B          | 16 W. 18th St. New York
 102 | P Inc      | 375 Hudson St, New York
  75 | D Inc      | 1540 Broadway, New York
  65 | H Pubs     | 10 E 53rd St, New York
  59 | R Inc      | 1540 Broadway, New York
(13 rows)
postgres=#
postgres=# -- Declares a cursor named cur_publisher and then uses that cursor to fetch 2 rows.
postgres=#
postgres=#
postgres=# BEGIN WORK;
BEGIN
postgres=# DECLARE cur_publisher CURSOR FOR SELECT name FROM publishers;
DECLARE CURSOR
postgres=# FETCH FORWARD 2 IN cur_publisher;
    name
------------
 Can Press
 Henry Inc.
(2 rows)
postgres=#
postgres=# close cur_publisher;
CLOSE CURSOR
postgres=# END WORK;
COMMIT
postgres=#
postgres=# drop table publishers;
DROP TABLE
postgres=#
postgres=#
           
       </source>