Subject | Re: [firebird-support] Re: foreign keys ans slow insert |
---|---|
Author | German Pablo Gentile |
Post date | 2004-09-30T09:14:21Z |
Martijn Tonies wrote:
:)
German.
>Helen, I disagree. Perhaps for this particular problem, one might createWell, thanks Martin for make me feel im not crazy.
>a CHECK constraint, but -- in general:
>
>* if the number of options can change -> FK
>* if there's more than just 'CASH' in the table, but a whole record with
> other data -> FK
>
>
>
>>create domain d_paytype char(6)
>>CHECK (VALUE IS NULL OR VALUE IN('CASH', 'CHEQUE','CREDIT'));
>>
>>
>
>IMO, this really is a FB implementation problem.
>
>
>
:)
German.