SPI_CURSOR_MOVE(3)

💅 SPI_CURSOR_MOVE(3) 💅

okay so bestie, this is the PostgreSQL 13.23 Documentation page for SPI_cursor_move, and it's short, sweet, and fully iconic. Let's get into it 💖✨

🎀 NAME 🎀

SPI_cursor_move — move a cursor, periodt. 💅

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

So SPI_cursor_move literally 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, bestie, go peek at SPI_scroll_cursor_move. 👀✨

🌸 ARGUMENTS 🌸

• Portal portal — the portal containing the cursor. It's the container, the home base, the main character of this parameter list. 🫶
• bool forward — true for move forward, false for move backward. Binary icon behavior, no cap. 💅
• long count — maximum number of rows to move. Like a row budget, but make it cursor. 🔥

💜 NOTES 💜

Moving backward may fail if the cursor's plan was not created with the CURSOR_OPT_SCROLL option. So yeah, backward vibes are not guaranteed unless that option is in the mix — that's literally what the docs say. 😭

xoxo, your PostgreSQL 13.23 documentation bestie, dated 2025, and this is SPI_CURSOR_MOVE(3) saying byeee 💖🎀✨