SPI_PREPARE_PARAMS(3)

💅 SPI_PREPARE_PARAMS(3) — prepare a statement, without executing it yet

okay bestie, welcome to the SPI_PREPARE_PARAMS(3) manual page ✨ this one is all about getting a statement prepared but not executed yet — like getting your outfit ready but not leaving the house 💖

---

🌸 NAME 🌸

SPI_prepare_params — prepare a statement, without executing it yet

---

🎀 SYNOPSIS 🎀

SPIPlanPtr SPI_prepare_params(const char * command,
                              ParserSetupHook parserSetup,
                              void * parserSetupArg,
                              int cursorOptions)

---

🦋 DESCRIPTION 🦋

SPI_prepare_params creates and returns a prepared statement for the specified command, but it doesn't execute the command. No cap, it just prepares it and hands it back to you 🫶

This function is equivalent to SPI_prepare_cursor, with the addition that the caller can specify parser hook functions to control the parsing of external parameter references. It's giving "same vibe, but with parser-hook customization" ✨

Heads up, bestie: this function is now deprecated in favor of SPI_prepare_extended 💅 so it's still iconic, but it's not the main character anymore.

---

💜 ARGUMENTS 💜

• const char * command — the command string 🧚
• ParserSetupHook parserSetup — the parser hook setup function 🌸
• void * parserSetupArg — the pass-through argument for parserSetup 🎀
• int cursorOptions — an integer bit mask of cursor options; zero produces default behavior ⭐

---

👑 RETURN VALUE 👑

SPI_prepare_params has the same return conventions as SPI_prepare. So whatever you'd expect from SPI_prepare, that's the energy here 💖

---

That's the whole page, bestie — every detail accounted for, every vibe slayed. 💅✨

This one comes from the PostgreSQL 17.11 Documentation, dated 2026 — mwah 😘💖