Insert results in 0 1

On Jan 15, 2018, at 5:57 PM, Sherman Willden <operasopranos@gmail.com> wrote:

Computer HP Compaq 6710b
Development Platform: Ubuntu 17.10 mainly command line work
Tools: perl 5.26 and postgresql 9.6

Why do I get a 0 1 when using insert?

Thanks;

Sherman
classical=# INSERT INTO string_groups VALUES('et_b_02', 'Sonata in B minor', 'Eroica Trio', 'Jean Baptiste Loeillet', 'Baroque');
INSERT 0 1
classical=# INSERT INTO string_groups VALUES('et_b_02', 'Sonata in B minor', 'Eroica Trio', 'Jean Baptiste Loeillet', 'Baroque');
ERROR: duplicate key value violates unique constraint "string_groups_pkey"
DETAIL: Key (id)=(et_b_02) already exists.

On successful completion, an INSERT command returns a command tag of the form

INSERT oid count
The count is the number of rows inserted or updated. If count is exactly one, and the target table has OIDs, then oid is the OID assigned to the inserted row. The single row must have been inserted rather than updated. Otherwise oid is zero.

On Mon, Jan 15, 2018 at 07:13:28PM -0700, Rob Sargent wrote:

On successful completion, an INSERT command returns a command tag of
the form

INSERT oid count
The count is the number of rows inserted or updated. If count is
exactly one, and the target table has OIDs, then oid is the OID
assigned to the inserted row. The single row must have been inserted
rather than updated. Otherwise oid is zero.

Please refer to the documentation as well, section "Outputs":
https://www.postgresql.org/docs/current/static/sql-insert.html
--
Michael