Question on INSERT statement - Mailing list pgsql-general

From Geoffrey KRETZ
Subject Question on INSERT statement
Date
Msg-id 40FB7E09.4070000@4js.com
Whole thread Raw
Responses Re: Question on INSERT statement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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 informix
or db2 for exemple, it will return an error.

So is that normal ?

Geoffrey Kretz - Four J's Development Tools

pgsql-general by date:

Previous
From: Anton Nikiforov
Date:
Subject: PGCluster in production
Next
From: Geoffrey KRETZ
Date:
Subject: UPDATE statement