Re: [SQL] Please help to wite the constraint.

2005-11-22 Thread Grigory O. Ptashko
th fixed range of values countires_names - values of the field Well, that was it, nothing more. Does it really look so wierd? Please, I appreciate any comments. > On 11/20/05, Grigory O. Ptashko <[EMAIL PROTECTED]> wrote: >> Hello, everybody! >> >> I don't whether it is po

[SQL] Please help to wite the constraint.

2005-11-20 Thread Grigory O. Ptashko
Hello, everybody! I don't whether it is possible to do the following but anyway I can't. I need to write a constraint as described below. Here are four tables: CREATE TABLE countries (id SERIAL, name VARCHAR(255), PRIMARY KEY (id) ); CREATE TABLE countries_names (id INT NOT NULL, id_lang INT