SPI_CURSOR_MOVE(3)

💅 SPI_cursor_move — the cursor scoot 💅

okay bestie, this is the SPI_CURSOR_MOVE(3) page from the PostgreSQL 15.19 Documentation, and it’s literally all about moving a cursor. no cap. ✨

🌸 NAME 🌸

SPI_cursor_move — move a cursor. that’s it, that’s the 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. it’s equivalent to a subset of the SQL command MOVE — and if you want more functionality, go check out SPI_scroll_cursor_move. iykyk. 💖

🎀 ARGUMENTS 🎀

• Portal portal — the portal containing the cursor. your cursor’s home base, fr. 🏠
• bool forward — true for move forward, false for move backward. pick your direction, bestie. ➡️⬅️
• long count — maximum number of rows to move. the ceiling, the limit, the max. 🔥

💀 NOTES 💀

moving backward may fail if the cursor’s plan was not created with the CURSOR_OPT_SCROLL option. that’s the tea: backward scooting may fail if that option wasn’t there when the plan was created. 😭

mwah 💋 — PostgreSQL 15.19, dated 2026, signing off. 🫶