SPI_PREPARE_EXTENDED(3)

💅 SPI_prePARE_EXTENDED(3) — PostgreSQL 15.19 docs, bestie edition 💅

okay so real talk, this one is a PostgreSQL 15.19 manual page and it's lowkey iconic. it's SPI_prepare_extended, and no cap, it's literally the glow-up version of preparing a statement. let's get into it ✨

---

🎀 NAME 🎀

SPI_prepare_extended — prepare a statement, without executing it yet 🫶

like, you're setting it up, you're not running it. think "outfit planned but not worn yet." main character prep energy fr fr.

---

🦋 SYNOPSIS 🦋

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

that's the whole vibe check right there 💖

---

🌸 DESCRIPTION 🌸

so SPI_prepare_extended creates and returns a prepared statement for the specified command, but bestie, it does not execute the command. it's giving "I made the plan, I did not attend the event."

this function is equivalent to SPI_prepare, with the addition that the caller can specify options to control the parsing of external parameter references, as well as other facets of query parsing and planning. so basically SPI_prepare but with extra sparkle ✨ and honestly? obsessed.

---

💜 ARGUMENTS 💜

• const char * command — command string. the actual command, the moment, the text itself 💅
• const SPIPrepareOptions * options — struct containing optional arguments. it's the little bag of settings 🎀

⚠️ okay this part is important, listen up: callers should always zero out the entire options struct, then fill whichever fields they want to set. this ensures forward compatibility of code, since any fields that are added to the struct in future will be defined to behave backwards-compatibly if they are zero. so zero first, fill after. no skipping, iykyk 😭

the currently available options fields are:

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

see how both of those last two are like "zero = default"? that's not a coincidence bestie, that's the whole zeroing-out theme. slay consistency 💖

---

👑 RETURN VALUE 👑

SPI_prepare_extended has the same return conventions as SPI_prepare. that's it, that's the tea 🍓

---

and that's the page!! ngl it ate. catch you in the next one, bestie 💅💖✨

🌟 sign-off time: this was SPI_PREPARE_EXTENDED(3) from PostgreSQL 15.19, dated 2026. mwah, go prepare something iconic 🎀🦋🌸