convert between data types and a second to apply the modifier.

</para>

<para>

A cast to or from a domain type currently has no effect. Casting

to or from a domain uses the casts associated with its underlying type.

</para>

</refsect1>

<refsect1 id="sql-createcast-notes">

aclcheck_error(aclresult,ACL_KIND_TYPE,

format_type_be(targettypeid));

if (sourcetyptype==TYPTYPE_DOMAIN)

ereport(WARNING,

(errcode(ERRCODE_WRONG_OBJECT_TYPE),

errmsg("cast will be ignored because the source data type is a domain")));

elseif (targettyptype==TYPTYPE_DOMAIN)

ereport(WARNING,

(errcode(ERRCODE_WRONG_OBJECT_TYPE),

errmsg("cast will be ignored because the target data type is a domain")));

if (stmt->func!=NULL)

castmethod=COERCION_METHOD_FUNCTION;

CREATE DOMAIN testdomain3b AS int;

CREATE FUNCTION castfunc(int) RETURNS testdomain3b AS $$ SELECT $1::testdomain3b $$ LANGUAGE SQL;

CREATE CAST (testdomain1 AS testdomain3b) WITH FUNCTION castfunc(int);

WARNING: cast will be ignored because the source data type is a domain

CREATE FUNCTION testfunc5b(a testdomain1) RETURNS int LANGUAGE SQL AS $$ SELECT $1 $$;

CREATE FUNCTION testfunc6b(b int) RETURNS testdomain1 LANGUAGE SQL AS $$ SELECT $1::testdomain1 $$;

CREATE OPERATOR !! (PROCEDURE = testfunc5b, RIGHTARG = testdomain1);