I think it is. There are also functions that will tell you what the
sequence for a given field in a given table is (might also be new in
8.1, but you could probably recreate them yourself).
Also, in 8.2 you'll be able to do INSERT ... RETURNING, which can
return the id directly back to you.
> 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?
Note that the upcoming 8.2 release has a handy "returning" clause
for insert:
http://developer.postgresql.org/pgdocs/postgres/sql-inser
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 pro
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 manua
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* inelega
