Re: The fable of DEMETRIUS, CONSTRAINTICUS, and AUTOMATICUS
Date: Wed, 20 Oct 2004 13:59:29 -0400
Message-ID: <xr2dnSzSmoIWOuvcRVn-iw_at_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 - 19:59:29 CEST