SPI_CURSOR_FETCH(3)

💅 SPI_CURSOR_FETCH(3) — bestie edition 💅

Okay so welcome to the SPI_cursor_fetch page from the PostgreSQL 17.11 Documentation, and yes bestie, we’re gonna make cursor fetching make sense. ✨

🎀 NAME 🎀

SPI_cursor_fetch — fetch some rows from a cursor. That’s the whole assignment, no cap. 💖

🦋 SYNOPSIS 🦋

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

🌸 DESCRIPTION 🌸

SPI_cursor_fetch fetches some rows from a cursor. It’s literally equivalent to a subset of the SQL command FETCH — and if you want more functionality, the page says to see SPI_scroll_cursor_fetch, iykyk. 💅

✨ ARGUMENTS ✨

• Portal portal — the portal containing the cursor, bestie. That’s the vibe.
• bool forward — true for fetch forward, false for fetch backward. Periodt.
• long count — maximum number of rows to fetch. The limit, the cap, the max. 👑

👑 RETURN VALUE 👑

SPI_processed and SPI_tuptable are set as in SPI_execute if successful. Slay. 💅

⭐ NOTES ⭐

Fetching backward may fail if the cursor’s plan was not created with the CURSOR_OPT_SCROLL option. So like… if you’re trying to go backward without that option, it’s giving “may fail,” and you should know that, fr fr. 😭

And that’s the page, bestie — signed off by PostgreSQL 17.11, dated 2026, with SPI_CURSOR_FETCH(3) living its main character moment. 🫶💖✨