I'm trying to create what amounts to a new type. This would be rather easy if I could perform a CHECK on a composite type, which I could do if I could create a domain on top of a composite. Is there any reason in particular that hasn't been done?
As an alternative, I tried accomplishing this with a straight domain. That would work, except for this:
WARNING: cast will be ignored because the source data type is a domain
Why do we ignore casts from domains to other data types? I'm guessing because it's simply not what domains were meant for?
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com