Re: What does "INSERT 0 1" mean? - Mailing list pgsql-general

From Terry Lee Tucker
Subject Re: What does "INSERT 0 1" mean?
Date
Msg-id 200910141145.42061.terry@chosen-ones.org
Whole thread Raw
In response to What does "INSERT 0 1" mean?  ("[.::MDT::.]" <mdt86@yahoo.it>)
List 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.

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: What does "INSERT 0 1" mean?
Next
From: Peter Hunsberger
Date:
Subject: Re: Query to find contiguous ranges on a column