Tomas Michalik wrote:

>
> Hi,
>
> 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.

Raymond Kennington