Re: The old Insert and retrieving your Serial problem in

That looks like the solution to my problem, thanks!...I tried running it
on my 8.0.8 server, but it wasn't found, I assume that's an 8.1 only
function?

Martijn van Oosterhout wrote:

>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,
>
>