Обсуждение: newbie question - INSERT

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

what means of 19748 and 1?

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

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

>what means of 19748 and 1?