SPI_CURSOR_MOVE(3)

✨ SPI_CURSOR_MOVE(3) ✨

okay so bestie, we're in the PostgreSQL 14.24 Documentation, and this is the SPI_CURSOR_MOVE(3) page — aka the little manual page about moving a cursor. no cap, it's giving "tiny but useful." 💅

---

🌸 NAME 🌸

SPI_cursor_move — move a cursor. literally what it says on the tin, bestie. 🎀

---

🦋 SYNOPSIS 🦋

void SPI_cursor_move(Portal portal, bool forward, long count)

---

💖 DESCRIPTION 💖

SPI_cursor_move skips over some number of rows in a cursor. yes, it's doing that little "hop over here" moment. ✨

This is equivalent to a subset of the SQL command MOVE — and if you want more functionality, go peek at SPI_scroll_cursor_move. iykyk. 👑

---

🎀 ARGUMENTS 🎀

• Portal portal — the portal containing the cursor. it's the holder of the cursor vibes. 🫶
• bool forward — true for move forward, false for move backward. simple as that. ⭐
• long count — maximum number of rows to move. that's the row budget, bestie. 💜

---

🌈 NOTES 🌈

Moving backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option. so like, watch out for that one 😭 — it's a real "may fail," not a "definitely will," but still.

---

mwah 💋 this iconic little page is from PostgreSQL 14.24, dated 2026, and it is the SPI_CURSOR_MOVE(3) manual page. slay and goodbye, bestie 💖