SPI_SCROLL_CURSOR_MOVE(3pg15)

💫 SPI_scroll_cursor_move — bestie edition 💫

okay so real talk: this is the SPI_scroll_cursor_move page from the PostgreSQL 15.19 docs (that's manual section 3, the library-call girlies), and it's genuinely so much simpler than the name makes it look. sit down, hydrate, let's go 🫶

---

✨ NAME ✨

SPI_scroll_cursor_move — literally just moving a cursor, that's the whole vibe 💅

---

✨ SYNOPSIS ✨

void SPI_scroll_cursor_move(Portal portal, FetchDirection direction,
                            long count)

look at her. three arguments. icon behavior, no notes 👑

---

✨ DESCRIPTION ✨

so SPI_scroll_cursor_move skips over some number of rows in a cursor. that's it, that's the function 🦋

it's equivalent to the SQL command MOVE — like, deadass the same thing, so if you already know MOVE you already know her, iykyk 💖

---

✨ ARGUMENTS ✨

• Portal portal — the portal that's holding the cursor. she's the main character here 👑
• FetchDirection direction — one of FETCH_FORWARD, FETCH_BACKWARD, FETCH_ABSOLUTE or FETCH_RELATIVE 🌈 pick your fighter.
• long count — the number, and what it means changes depending on direction (rude, but okay):
  • number of rows to move for FETCH_FORWARD or FETCH_BACKWARD
  • absolute row number to move to for FETCH_ABSOLUTE
  • relative row number to move to for FETCH_RELATIVE

ngl, that last one is the part everyone gets wrong, so like… read it twice bestie 🎀

---

✨ RETURN VALUE ✨

if it works, SPI_processed gets set exactly as in SPI_execute. slay ✅

and SPI_tuptable is set to NULL, because no rows are returned by this function — she doesn't bring you snacks, she just moves 💀 like okay, fair enough.

---

✨ NOTES ✨

• for the details on how direction and count are interpreted, see the SQL FETCH(7) command 📖 (yes, go read it, it ate).
• any direction value other than FETCH_FORWARD may fail if the cursor's plan wasn't created with the CURSOR_OPT_SCROLL option 🚨 no cap, that's a real limitation, so don't come for me when it errors out 🙈

---

ok that's the whole page, you're officially a cursor-moving girlie now 🔥 go forth and scroll, carefully 💜

---

🎀 that's a wrap, babe! this came straight from the PostgreSQL 15.19 docs, dated 2026, and the whole thing is filed under SPI_scroll_cursor_move(3) — mwah, see you in the next manpage 💖✨🍓