DROP_OPERATOR(7pg13)

💅 DROP OPERATOR 💅

okay bestie, so this is the <pink>DROP OPERATOR</pink> page from the PostgreSQL 13 docs (7pg13, we love a reference manual moment) — and it's literally the "bye bitch" button for operators in your database. Let's get into it 🫶

---

✨ SYNOPSIS ✨

DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , { right_type | NONE } ) [, ...] [ CASCADE | RESTRICT ]

no cap, that's the whole thing. it's giving "one line, all the power" 💅

---

🌸 DESCRIPTION 🌸

DROP OPERATOR drops an existing operator from the database system. that's it, that's the vibe — the operator is gone, poof, iconic exit 💨✨

but listen, <red>you must be the owner of the operator</red> to run this command. like, ownership check first, always. fr fr don't try it if it's not yours, it's not giving main character energy 😭

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the operator doesn't exist. instead you just get a notice issued in this case. lowkey polite, highkey useful 🙈
• name — the name of an existing operator, optionally schema-qualified. yes you can be fancy with the schema quals ✨
• left_type — the data type of the operator's left operand. and if the operator has no left operand, you literally write NONE. not "nothing", not blank — NONE. periodt 💅
• right_type — the data type of the operator's right operand. same deal: write NONE if the operator has no right operand 🎀
• CASCADE — automatically drop objects that depend on the operator (such as views using it), and in turn all objects that depend on those objects (see Section 5.14). it's giving ripple effect, it's giving chain reaction 🔥 careful tho, that's a lot of collateral 💀
• RESTRICT — refuse to drop the operator if any objects depend on it. and guess what bestie, this is the default. so unless you say otherwise, it's a hard no on the cascade vibes 🛑⭐

---

🦋 EXAMPLES 🦋

remove the power operator a^b for type integer:

DROP OPERATOR ^ (integer, integer);

remove the left unary bitwise complement operator ~b for type bit:

DROP OPERATOR ~ (none, bit);

remove the right unary factorial operator x! for type bigint:

DROP OPERATOR ! (bigint, none);

remove multiple operators in one command — yes you can do a whole batch, we love efficiency 👑

DROP OPERATOR ~ (none, bit), ! (bigint, none);

---

🌈 COMPATIBILITY 🌈

ngl, there is <hotpink>no DROP OPERATOR statement in the SQL standard</hotpink>. it's a PostgreSQL exclusive little moment, iykyk 💜

---

💖 SEE ALSO 💖

• CREATE OPERATOR (CREATE_OPERATOR(7))
• ALTER OPERATOR (ALTER_OPERATOR(7))

---

bestie reminder okay: <yellow>CASCADE</yellow> is fun until it's not. it'll take the dependent views and everything hanging off those too. if you're not sure, stick with the default RESTRICT and vibe check your dependencies first 🙈💀

---

mwah 💋 this was PostgreSQL 13.23 documentation, dated 2025, page DROP OPERATOR(7) — go forth and drop responsibly, queen 👑✨