SPI_CURSOR_MOVE(3)

✨ NAME ✨

okay so bestie, welcome to SPI_CURSOR_MOVE(3) — it's giving PostgreSQL 17.11 docs energy, and this page is all about SPI_cursor_move, which is literally “move a cursor” 💅. no cap, that’s the whole vibe.

🎀 SYNOPSIS 🎀

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

💖 DESCRIPTION 💖

SPI_cursor_move skips over some number of rows in a cursor. lowkey it’s equivalent to a subset of the SQL command MOVE — and if you want more functionality, see SPI_scroll_cursor_move, iykyk 🦋.

🌸 ARGUMENTS 🌸

• Portal portal — the portal containing the cursor, aka where the cursor lives 🫶
• bool forward — true for move forward, false for move backward. fr fr, that’s the direction switch ⭐
• long count — the maximum number of rows to move. iconic limit behavior 👑

🦋 NOTES 🦋

bestie, heads up: moving backward may fail if the cursor’s plan was not created with the CURSOR_OPT_SCROLL option 😭. not me being dramatic, that’s just the rule 💀

mwah 💋 — signing off from the PostgreSQL 17.11 docs, dated 2026, and this was SPI_CURSOR_MOVE(3) 🫶