3.6、提取该查询的第x行

  1. postgres=# FETCH ABSOLUTE 2 from tbase_cur ;
  2. id | nickname
  3. ----+-----------
  4. 2 | TBase
  5. (1 row)
  6. postgres=# FETCH ABSOLUTE -1 from tbase_cur ;
  7. id | nickname
  8. ----+------------
  9. 5 | TBase swap
  10. (1 row)
  11. postgres=# FETCH ABSOLUTE -2 from tbase_cur ;
  12. id | nickname
  13. ----+---------------
  14. 4 | TBase default
  15. (1 row)

X为负数时则从尾部向上提