reference to a view
От | Joolz |
---|---|
Тема | reference to a view |
Дата | |
Msg-id | 20040616084110.GA9018@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: reference to a view
|
Список | pgsql-general |
In my db I have a table type_of_action, fields code varchar, name varchar, medical boolean. Two other tables refer to this table, one of them to the medical rows, the other one to the none-medical rows. I would like to make the reference with a view, like this: create table type of action_type ( code varchar, name varchar, medical boolean ); create view action_type_medical as select * from action_type where medical=true; create view action_type_non_medical as select * from action_type where medical=false; create table general_actions ( field1, field2, field_etc, action_type varchar references action_type_non_medical(code) ); create table medical_actions ( field1, field2, field_etc, action_type varchar references action_type_medical(code) ); But pg refuses this, can't create a reference to a view. I can now create a trigger plus function that will do the check, but is there a more elegant way? Thanks! -- 10:35-10:41 Fedora Core release 2 (Tettnang) Linux 2.6.6-1.435
В списке pgsql-general по дате отправления: