Synopsis
Use the DROP CAST statement to remove a cast.
Syntax
Grammar
DiagramSemantics
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);