I don't work with M$ DBs, but saw that "autonumber" is an M$ concept. Purely for my own edification, how do you get the most resent value of an autonumber in M$? I was helping someone out who was using M$ stuff and was amazed that there was no currval function.
Thanks,
Rick
Scott Marlowe
<[EMAIL PROTECTED] To: lorid <[EMAIL
PROTECTED]>
orks.com> cc:
[email protected]
Sent by: Subject: Re: [SQL] getting
back autonumber just inserted
[EMAIL PROTECTED]
tgresql.org
02/03/2005 05:16 PM
On Thu, 2005-02-03 at 16:16, lorid wrote:
> I could have sworn I kept a copy of prior emails that discussed how to
> get back a value that was just inserted into a autonumber (or in
> postgresql case a sequence number)
If you know the name of the sequence the number came from you can use
currval():
insert into table1 (info) values ('abc');
select currval('table1seq');
Assuming table1seq is the name of the sequence here.
In 8.0 there's a function to do this (I'm not sure of the name, but a
quick search of the 8.0 docs should turn it up.)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
