Re: [GENERAL] RULES and QUALIFICATION for INSERT

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 insert. Should it generate

Re: [GENERAL] RULES and QUALIFICATION for INSERT

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 SELECT * FROM a NATUR

Re: [GENERAL] RULES and QUALIFICATION for INSERT

srdjan wrote: >>> -- 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)); >>> >>> insert into a values ('tom',5); >>> insert into a values ('paul',99); >>> insert into a value

Re: [GENERAL] RULES and QUALIFICATION for INSERT

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 insert. Should it generate an error message or

Re: [GENERAL] RULES and QUALIFICATION for INSERT

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 SELECT * FROM a NATURAL JOIN b;

[GENERAL] RULES and QUALIFICATION for INSERT

Hi to everyone. 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)); insert into a values ('tom',5); insert into a values ('paul',99);