pginfo wrote:
>
> Hmm, Ok I try to explain:
Try again. I can't quite get what you mean.
>If I write: insert into table_1 values ('f1_value',10);
>
>It is error because I try to insert 2 fields in 3-fields table. The
>reason is that I can make write error.
If your table is:
create table_1 (
a text,
b int,
c int
);
Why should insert into table_1 values ('f1_value',10) be an error?
Explain to me why the above SQL query is wrong and maybe I can help you.
But I can't see why a DB should give an error. If you want to force the
user to give values for *every* column when doing an insert then all you
need to do is create a table like this:
create table_1 (
a text NOT NULL,
b int NOT NULL,
c int NOT NULL
);
Maybe I am missing your point?
Jc