Re: Insert results in 0 1 - Mailing list pgsql-general

From Michael Paquier
Subject Re: Insert results in 0 1
Date
Msg-id 20180116053617.GC2212@paquier.xyz
Whole thread Raw
In response to Re: Insert results in 0 1  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Insert results in 0 1
Next
From: NTPT
Date:
Subject: Re: why SSD is slower than HDD SAS 15K ?