Re: [GENERAL] insert explanation - Mailing list pgsql-general

On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:

> Simon Drabble wrote:
> >
> > On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote:
> >
> > > Dear all,
> > >
> > > mydb=> create table rtext (rtext varchar(10));
> > > CREATE
> > > mydb=> insert into rtext values ('hello');
> > > INSERT 17681 1
> > >
> > > What do "17681" and "1" mean?
> > >
> > > Could someone help me to understand this please?
> > >
> > > Regards,
> > > Chai
> >
> > 17681: oid (object ID) of the inserted row
> > 1: number of rows inserted.
> >
>
>
> Why does it start from 17681?
> This is a fresh new table, shouldn't it start from 1?
>

   Because another records in pg_... tables have a oid numbers...

  --Greg--