Re: Seeking Equivalent of InterBase Domain

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 22 Jan 2007 10:12:43 -0800
Message-ID: <1169489558.935801@bubbleator.drizzle.com>

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Jan 22 2007 - 12:12:43 CST