| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | Sherman Willden <operasopranos(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Insert results in 0 1 |
| Date: | 2018-01-16 05:36:17 |
| Message-ID: | 20180116053617.GC2212@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NTPT | 2018-01-16 07:44:53 | Re: why SSD is slower than HDD SAS 15K ? |
| Previous Message | Rob Sargent | 2018-01-16 02:13:28 | Re: Insert results in 0 1 |