Raymond Kennington wrote:

>
> Tomas Michalik wrote:
> >
> > my problem is:
> > I create a domain with check constraint.
> >
> > e.g.
> > ALTER DOMAIN D_TRANSPORT_TYPE_ID
> > ADD CHECK (exists
> > (
> > select *
> > from transport_types
> > where tt_id = value
> > ))
> >
> Not an answer to your question, but I'd use a foreign key constraint instead of a domain.

But then you have to create many foreign keys (we use this domain on
many places). Defining this constraint on a domain saves (actually would
save :-| ) work. And then there is still the problem with necessity of
creating indexes for foreign keys ...

Regards,
Tom

=================================

Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic

e-mail: michalik@...
tel: +420 2 67283446