RE: AW: [HACKERS] Getting OID in psql of recent insert

> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Zeugswetter
> Andreas SEV
> Sent: Tuesday, November 23, 1999 5:58 PM
> To: 'pgsql-hackers(at)postgreSQL(dot)org'
> Subject: AW: AW: [HACKERS] Getting OID in psql of recent insert
>
> >
> > > Is someone still working on the xid access ?
> >
> > I think we have the ability to refer to CTID in WHERE now,
>
> Do we use the sql syntax 'where rowid = :xxx' for it,
> or do we say 'where ctid = :xxx'.
> I would like the rowid naming, because Informix, Oracle (and DB/2
> ?) use it.
>

You could say 'where ctid= ...' in current tree.
It has been rejected due to the lack of equal operator for type TID.
The syntax itself has been allowed by parser.

> > but not yet an access method that actually makes it fast...
>
> Well that is of course only half the fun :-(
> Could it be done like an index access,
> where the first part of the work is skipped, or tunneled through ?

I would commit the implementation of direct scan by tuple id soon.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp