Question on INSERT statement

From: Geoffrey KRETZ <gk(at)4js(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question on INSERT statement
Date: 2004-07-19 07:53:45
Message-ID: 40FB7E09.4070000@4js.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey KRETZ 2004-07-19 08:45:44 UPDATE statement
Previous Message Anton Nikiforov 2004-07-19 05:46:57 PGCluster in production