Re: [GENERAL] Question on INSERT statement

2004-07-19 Thread Tom Lane
Geoffrey KRETZ <[EMAIL PROTECTED]> writes: > I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching > the following request : > INSERT INTO temp_tab VALUES (1,2,3) > It will insert the values in the three first row whereas with informix > or db2 for exemple, it will return an err

Re: [GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
Richard Huxton wrote: Geoffrey KRETZ wrote: I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request : INSERT INTO temp_tab VALUES (1,2,3) It will insert the values in the three first row whereas with informix or db2 for exemple, it will return an error. So

[GENERAL] Question on INSERT statement

2004-07-19 Thread Geoffrey KRETZ
Hello, I'm wondering if the following behaviour is the correct one for PostGreSQL (7.4 on UNIX). I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request : INSERT INTO temp_tab VALUES (1,2,3) It will insert the values in the three first row whereas with info