Re: The old Insert and retrieving your Serial problem in VB - Mailing list pgsql-general

On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote:
> I am once again dealing with that age old problem of retrieving the
> value of your inserted serial field in VB.  I am fully aware that I can
> manually pull the currval or nextval from my sequence, but I consider
> having to manually deal with an auto-generated database object an
> *extremely* inelegant solution.

Maybe you're looking for lastval()?

http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.