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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers