Thread: 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
isthe 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