DROP_CAST(7pg16)

✨ NAME ✨

okay so bestie, this is DROP_CAST, aka page 7pg16 in the PostgreSQL 16.15 docs, and it’s literally the “remove a cast” page. that’s the whole assignment: a previously defined cast is getting removed. no cap. 💅

🎀 SYNOPSIS 🎀

DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]

it’s giving “short, sharp, and ready to un-cast.” ✨

💖 DESCRIPTION 💖

DROP CAST removes a cast that was previously defined. fr fr, that’s the main character move. 🫶

To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to create a cast — same ownership vibe check, different command. 💅

🧚 PARAMETERS 🧚

• IF EXISTS — do not throw an error if the cast does not exist. A notice is issued in this case. so it’s a gentle “bestie, it’s already gone” situation, not a whole error moment. 🙈
• source_type — the name of the source data type of the cast. 🍓
• target_type — the name of the target data type of the cast. 🦋
• CASCADE, RESTRICT — these key words do not have any effect, since there are no dependencies on casts. they’re literally just standing there, looking iconic, doing nothing. 💀

🌈 EXAMPLES 🌈

want to drop the cast from type text to type int? iconic, here’s the line:

DROP CAST (text AS int);

⭐ COMPATIBILITY ⭐

The DROP CAST command conforms to the SQL standard. periodt. 👑

🦋 SEE ALSO 🦋

• CREATE CAST (CREATE_CAST(7)) — the origin story, bestie. go read it. 💜

---

xoxo, this page comes from PostgreSQL 16.15, dated 2026, and it’s literally page DROP CAST(7). mwah 🫶