Re: Seeking Equivalent of InterBase Domain

In message <1169489558.935801_at_bubbleator.drizzle.com>, DA Morgan <damorgan_at_psoug.org> writes
>Jim Smith wrote:
>> In message <1169405574.80550_at_bubbleator.drizzle.com>, DA Morgan
>><damorgan_at_psoug.org> writes
>>> Martijn Tonies wrote:
>>>
>>>> Can you assign a "check constraint" to a type?
>>>
>>> CREATE TABLE department_mgrs (
>>> dept_no NUMBER PRIMARY KEY,
>>> dept_name CHAR(20),
>>> dept_mgr person_typ,
>>> dept_loc location_typ,
>>> CONSTRAINT dept_loc_cons1
>>> UNIQUE (dept_loc.building_no, dept_loc.city),
>>> CONSTRAINT dept_loc_cons2
>>> CHECK (dept_loc.city IS NOT NULL) );
>>>
>> So that would be "No".
>
>You have a different interpretation of:
>
>CHECK (dept_loc.city IS NOT NULL) );
>
>Than I do.

As discussed earlier in the thread, the requirement is to create a type and add a constraint to the type. Not apply the constraint to a column which uses the type.

e.g.

create type positive_integer number(10,0) contraint pos_con (check positive_integer > 0);

create table x
( ...

   age positive_integer,
   ...
);

This can't be done in oracle.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>