Dmitry Yemanov wrote:

> "Claudio Valderrama C." <cvalde@...> wrote:
>
>> Is TYPE OF in the standard?
>>
>
> Nope. And neither is BASED ON.
>
>
>> Otherwise, what's wrong with BASED ON?
>>
>
> 1) TYPE OF explicitly suggests that we deal with a datatype only and assumes
>
> that constraints are being ignored.
> 2) TYPE OF requires no new keywords :-)
>

And looks good after "AS": CAST(value AS TYPE OF domain).
Based on can't: CAST(value AS BASED ON domain).


Adriano