Re: What does "INSERT 0 1" mean?

From: Terry Lee Tucker <terry(at)chosen-ones(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What does "INSERT 0 1" mean?
Date: 2009-10-14 15:45:42
Message-ID: 200910141145.42061.terry@chosen-ones.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 14 October 2009 11:05, [.::MDT::.] wrote:
> Hi,
> I can't find what does
> INSERT 0 1
> mean.
>
> "1" stands for the number of the records added to the table, as far as I
> understood, but what about the "0"?
>
> Thank you very much.
> --
> View this message in context:
> http://www.nabble.com/What-does-%22INSERT-0-1%22-mean--tp25892901p25892901.
>html Sent from the PostgreSQL - general mailing list archive at Nabble.com.

It represents the OID, which PostgreSQL, in earlier versions, generated by
default. Later versions do not do this by default. The zero indicates that
you are not generating OID's for that table.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-10-14 16:56:03 Re: Cannot start the postgres service
Previous Message Raymond O'Donnell 2009-10-14 15:38:11 Re: What does "INSERT 0 1" mean?