[GENERAL] 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] What does INSERT 0 1 mean?
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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] What does INSERT 0 1 mean?
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general