SPI_CURSOR_FETCH(3)

💖 NAME 💖

SPI_cursor_fetch — fetch some rows from a cursor. This is the SPI_CURSOR_FETCH(3) manual page, bestie, and it’s short but iconic ✨

---

🎀 SYNOPSIS 🎀

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

---

🌸 DESCRIPTION 🌸

Okay so 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, go see SPI_scroll_cursor_fetch, iykyk 🦋

---

✨ ARGUMENTS ✨

• Portal portal — portal containing the cursor 👑
• bool forward — true for fetch forward, false for fetch backward 🎀
• long count — maximum number of rows to fetch 💅

---

🔥 RETURN VALUE 🔥

SPI_processed and SPI_tuptable are set as in SPI_execute if successful. That’s the whole vibe 💖

---

💀 NOTES 💀

Fetching backward may fail if the cursor’s plan was not created with the CURSOR_OPT_SCROLL option. Not me warning you dramatically, but fr fr watch out for that 🙈

---

xoxo, PostgreSQL 14.24 Documentation, dated 2026 — mwah 🎀💋