Re: last entry

If you mean the value of the primary key (if a sequence is used) the way to do that is (in the same connection) to issue a "select currval('sequencename')" which will return the last used value of that sequence within the current connection.

If you mean the OID, there is a way to do that too, but I don't use them for ID so I don't know.

Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding(at)tpchd(dot)org

We have only two things to worry about: That things will never get
back to normal, and that they already have.

>>> mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za> 08/16/02 01:33AM >>>

Is it possible to identify the last entry that has been just insterted
into a table?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster