SPI_PREPARE_EXTENDED(3)

💖 SPI_PREPARE_EXTENDED — the spi_prepare_extended(3) glow-up 💖

okay bestie, sit down, hydrate, and let's talk about SPI_prepare_extended — straight outta the PostgreSQL 18.6 docs, section 3 of the manual, and yes she's iconic ✨

---

✨ NAME ✨

SPI_prepare_extended — prep a statement, but like… don't run it yet 💅

---

🌸 SYNOPSIS 🌸

SPIPlanPtr SPI_prepare_extended(const char * command,
                                const SPIPrepareOptions * options)

---

🦋 DESCRIPTION 🦋

so SPI_prepare_extended literally creates and returns a prepared statement for the command you hand it, and then just… doesn't execute it. she's giving ✨patience✨, she's giving main character energy, she's waiting for her moment 🎀

fr fr, this function is the same girl as SPI_prepare, except — and this is the slay — the caller gets to specify options that control how external parameter references get parsed, plus other little facets of query parsing and planning 🫶

---

🎀 ARGUMENTS 🎀

• const char * command — the command string, aka the whole vibe you're preparing 💖
• const SPIPrepareOptions * options — a struct holding the optional arguments, aka the lil extras 🌈

ok important bestie note: callers should always zero out the entire options struct first, and only then fill in whichever fields they actually wanna set. this is not a drill 🚨 it keeps your code forward-compatible, because any fields added to the struct in the future are defined to behave backwards-compatibly when they're zero. zero = default, periodt 👑

the options fields available rn are:

• ParserSetupHook parserSetup — the parser hook setup function 🔥
• void * parserSetupArg — the pass-through argument for parserSetup 🍓
• RawParseMode parseMode — mode for raw parsing; RAW_PARSE_DEFAULT (which is zero) produces the default behavior ⭐
• int cursorOptions — integer bit mask of cursor options; zero produces the default behavior 💜

---

⭐ RETURN VALUE ⭐

SPI_prepare_extended has the exact same return conventions as SPI_prepare. no cap, same energy, same rules 🌈

---

💀 lowkey a warning but make it cute: everything above is straight from the source, so don't be out here guessing at behavior. if it's not written here, it's not written here 🙈

---

and that's the whole page, bestie 🧚‍♀️ go forth and prepare those statements responsibly — love u, stay parsed 💖

PostgreSQL 18.6 · 2026 · SPI_PREPARE_EXTENDED(3) — mwah, signing off 💋👑