Albe Laurenz wrote:
srdjan wrote:
What is the desired response to
INSERT INTO vvv (name, town, num) VALUES ('Karl', 'Leipzig', 18);
Should this generate an error message, do nothing, or insert something?
In this case you shouldn't be able to do this
Albe Laurenz wrote:
srdjan wrote:
I'll try to explain my problem with an example.
-- I've got 2 tables and one view
CREATE TABLE a (name varchar(20) primary key, num integer);
CREATE TABLE b (town varchar(15), name varchar(20) references a(name));
CREATE VIEW vvv AS SELEC
d overcame this
problem with a trigger, but I'd prefer if someone could explain me how
to do this with rules).
Best regards
Srdjan Matic
Hi to everyone.
I've got some problem with rules.
-- I have 2 tables
CREATE TABLE a (email varchar(20), name varchar(10), num1 smallint, num2
smallint, PRIMARY KEY (email, name));
CREATE TABLE b (id smallint PRIMARY KEY, email_a varchar(20), name_a
varchar(10), tot smallint, FOREIGN KEY (e
