newbie question - INSERT

On Tue, 10 Apr 2001, Cefull Lo wrote:

When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1

what means of 19748 and 1?

19748 is the OID of that record, and 1 means one record was inserted.

For information on OID's, look in the documentation.

--
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/

On Tue, 10 Apr 2001, Cefull Lo wrote:

When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1

what means of 19748 and 1?

It's the OID, a unique idenifier for everything in the database.
Read the Momjian book on the website -- it explains this very well.

--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington

19748 is the Object ID (OID) The first ~17,000 OID's are reserved for
the system.

1 is the number of inserted rows.

Jeff