SPI_CURSOR_MOVE(3)

💫 SPI_CURSOR_MOVE(3) 💫

okay so bestie, this one's from the PostgreSQL 16.15 Documentation — it's a SPI (server programming interface) function, and it's literally just about scooting a cursor around. lowkey iconic, fr fr.

---

✨ NAME ✨

SPI_cursor_move — move a cursor 🎀

---

🌸 SYNOPSIS 🌸

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

that's the whole thing. she's short, she's sweet, she does exactly one job 💅

---

🦋 DESCRIPTION 🦋

so SPI_cursor_move skips over some number of rows in a cursor. that's it. that's the vibe ✨

it's equivalent to a subset of the SQL command MOVE — and if you want more functionality than this little subset gives you, go check out SPI_scroll_cursor_move instead. iykyk 🫶

---

🍓 ARGUMENTS 🍓

• Portal portal — the portal containing the cursor. that's your cursor's home base, her main character location 💖
• bool forward — true means move forward, false means move backward. yes queen, direction matters 😌
• long count — the maximum number of rows to move. emphasis on maximum — she's not gonna move more than that, no cap 🚫

---

💀 NOTES 💀

⚠️ moving backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option. so like… if you're going backwards and it's not working, that's probably why. not your fault bestie, it's the plan 😭

---

👑 SEE ALSO 👑

not gonna lie, the original page doesn't list any SEE ALSO references — so there's nothing to link here, and we're not about to invent one, periodt 💅

---

so yeah! that's the whole page. go forth and move those cursors, bestie — forward or backward (assuming your plan is scroll-y enough). 🌈⭐💜

this page came to you from PostgreSQL 16.15, dated 2026 — and it's the SPI_CURSOR_MOVE(3) page in the PostgreSQL documentation set. mwah, bye 🎀💖🧚