Postgres Pro
Downloads
Home   >   mailing lists

Thread: What does "INSERT 0 1" mean?

What does "INSERT 0 1" mean?

From
"[.::MDT::.]"
Date:
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.

Re: What does "INSERT 0 1" mean?

From
Raymond O'Donnell
Date:
On 14/10/2009 16: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"?

It stands for the OID of the row that was inserted, if the table was
created to use them (CREATE TABLE .... WITH (OIDS=TRUE)); newer versions
of PostgreSQL by default have tables created without OIDs on the rows,
so you just get a 0 returned instead.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Re: What does "INSERT 0 1" mean?

From
Terry Lee Tucker
Date:
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.