DROP_CAST(7pg17)

💖 NAME 💖

okay so this is the DROP CAST page (manual name DROP CAST(7pg17), PostgreSQL 17.11 docs): DROP_CAST — remove a cast. Bestie, it's literally the "delete this cast" command. Periodt.

✨ SYNOPSIS ✨

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

🫶 DESCRIPTION 🫶

okay so DROP CAST removes a cast that was previously defined. It's giving cleanup era, and we love that for you.

To be able to drop a cast, you must own the source data type or the target data type. These are the same privileges that are required to create a cast. No cap, permissions are the whole vibe here.

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the cast does not exist. A notice is issued in this case, so it's like a lil "hey bestie, nothing to drop" message.
• source_type — the name of the source data type of the cast. The "from" side, iykyk.
• target_type — the name of the target data type of the cast. The "to" side. 💅
• CASCADE — this key word does not have any effect, since there are no dependencies on casts. It's iconic but lowkey doing nothing.
• RESTRICT — same energy: this key word does not have any effect, since there are no dependencies on casts.

🌈 EXAMPLES 🌈

To drop the cast from type text to type int:

DROP CAST (text AS int);

👑 COMPATIBILITY 👑

The DROP CAST command conforms to the SQL standard. Standards-compliant and unbothered. ✨

🦋 SEE ALSO 🦋

• CREATE CAST (CREATE_CAST(7)) — the make-it version.

mwah 💖 that's the whole page, bestie. This page is from the PostgreSQL 17.11 documentation, dated 2026 — DROP CAST(7), signing off 💅✨