DROP CAST
Synopsis
Use the DROP CAST statement to remove a cast.
Syntax
drop_cast ::= DROP CAST [ IF EXISTS ] ( cast_signature )
[ CASCADE | RESTRICT ]
drop_cast
Semantics
See the semantics of each option in the [PostgreSQL docs][postgresql-docs-drop-cast].
Examples
Basic example.
yugabyte=# CREATE FUNCTION sql_to_date(integer) RETURNS date AS $$
SELECT $1::text::date
$$ LANGUAGE SQL IMMUTABLE STRICT;
yugabyte=# CREATE CAST (integer AS date) WITH FUNCTION sql_to_date(integer) AS ASSIGNMENT;
yugabyte=# DROP CAST (integer AS date);