SPI_CURSOR_MOVE(3)

✨ NAME ✨

omg hi bestie 💖 welcome to the PostgreSQL 18.6 Documentation page for SPI_CURSOR_MOVE(3) — it's literally all about moving a cursor. No cap, that's the whole name vibe: SPI_cursor_move — move a cursor. 🦋

🦋 SYNOPSIS 🦋

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

💅 DESCRIPTION 💅

okay so SPI_cursor_move skips over some number of rows in a cursor. It's giving a subset of the SQL command MOVE — and if you want more functionality, go look at SPI_scroll_cursor_move. Periodt. 💅

🌸 ARGUMENTS 🌸

• Portal portal — the portal containing the cursor. That's where the cursor lives, bestie. 🫶
• bool forward — true for move forward, false for move backward. Choose your adventure. ✨
• long count — maximum number of rows to move. Like, the row budget. 🔥

🎀 NOTES 🎀

⚠️ moving backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option. So don't be shocked if backward movement isn't giving what you need — it's a real caveat, fr fr. 😭

mwah 💋 that's the whole page. This was SPI_CURSOR_MOVE(3) from PostgreSQL 18.6, dated 2026. byeeee 🫶💖