Re: The fable of DEMETRIUS, CONSTRAINTICUS, and AUTOMATICUS

From: Laconic2 <laconic2_at_comcast.net>
Date: Wed, 20 Oct 2004 13:59:29 -0400
Message-ID: <xr2dnSzSmoIWOuvcRVn-iw@comcast.com>

"Marshall Spight" <mspight_at_dnai.com> wrote in message news:Q3wdd.217587$wV.174119_at_attbi_s54...

> I must say I am impressed with your creativity. However, I find this
> exact solution unsatisfying, but I have a *related* idea which you
> may find interesting.
>
> What if we could *declare* a set according to its properties (constraints,
> really) and use them as if they were regular sets? So we could have
> a set ValidSalaries that was declarad as the set of all integers between
> 0 and 100,000?

I hate to keep beating the same dead horse, but won't CREATE DOMAIN do exactly this?

CREATE DOMAIN valid_salary CONSTRAINT valid_salary BETWEEN 0 AND 100000;

CREATE TABLE EMPLOYEES
(...
SALARY VALID_SALARY,
...); Received on Wed Oct 20 2004 - 12:59:29 CDT