Re: What Does "INSERT 0 1" Mean? - PostgreSQL

Home » What Does 0-1 Mean » Re: What Does "INSERT 0 1" Mean? - PostgreSQL

Maybe your like

PostgreSQL Elephant Logo
  • Home
  • About
  • Download
  • Documentation
  • Community
  • Developers
  • Support
  • Donate
  • Your account

Quick Links

  • Community
  • Contributors
  • Mailing Lists
  • IRC
  • Local User Groups
  • Events
  • International Sites
Re: What does "INSERT 0 1" mean?
From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: "[(dot)::MDT::(dot)]" <mdt86(at)yahoo(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What does "INSERT 0 1" mean?
Date: 2009-10-14 15:38:11
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread: 2009-10-14 15:05:39 from "[(dot)::MDT::(dot)]" <mdt86(at)yahoo(dot)it> 2009-10-14 15:38:11 from Raymond O'Donnell <rod(at)iol(dot)ie> 2009-10-14 15:45:42 from Terry Lee Tucker <terry(at)chosen-ones(dot)org>
Lists: pgsql-general

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 wascreated to use them (CREATE TABLE .... WITH (OIDS=TRUE)); newer versionsof 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, Irelandrod(at)iol(dot)ieGalway Cathedral Recitals: http://www.galwaycathedral.org/recitals------------------------------------------------------------------

In response to

  • What does "INSERT 0 1" mean? at 2009-10-14 15:05:39 from [.::MDT::.]

Browse pgsql-general by date

From Date Subject
Next Message Terry Lee Tucker 2009-10-14 15:45:42 Re: What does "INSERT 0 1" mean?
Previous Message Raymond O'Donnell 2009-10-14 15:27:56 Re: COPY BINARY 8.3 to 8.4 timestamp incorrect

Tag » What Does 0-1 Mean