Re: pg and number of parameters by insert

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