SPI_CURSOR_FETCH(3)

💖 NAME 💖

okay bestie, welcome to SPI_CURSOR_FETCH(3) from the PostgreSQL 16.15 Documentation — this one is literally about SPI_cursor_fetch, which fetches some rows from a cursor. iconic behavior, no cap.

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

So SPI_cursor_fetch fetches some rows from a cursor. That’s the whole vibe. 💅

It’s equivalent to a subset of the SQL command FETCH — and if you want more functionality, go look at SPI_scroll_cursor_fetch, because that one has extra main character energy. 👑

🎀 ARGUMENTS 🎀

• Portal portal — the portal containing the cursor 🫶
• bool forward — true for fetch forward, false for fetch backward 🔥
• long count — maximum number of rows to fetch ⭐

🌈 RETURN VALUE 🌈

If it’s successful, SPI_processed and SPI_tuptable are set as in SPI_execute. periodt. 💖

🌸 NOTES 🌸

Fetching backward may fail if the cursor’s plan was not created with the CURSOR_OPT_SCROLL option. bestie, consider this your vibe check before going backward. 😭

mwah 💋 — this little page is sourced from PostgreSQL 16.15, dated 2026. catch you in the next manpage, bestie! 🎀✨🦋