Обсуждение: What does "INSERT 0 1" mean?
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.
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 ------------------------------------------------------------------
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.