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.