Re: Does INSERT inserts always at the end ?

jseymour(at)LinxNet(dot)com (Jim Seymour) wrote :

> Define what you mean by "with a script." If you've a db handle open
> with, say, Perl's DBI, you could simply do a select on currval() for
> the sequence and get it. This is immune to other transactions.

Indeed, I'm using Perl's DBI. currval does exactly what I want. Thanks to
all who pointed it to me.

Before I could read your messages, I made a workaround that worked nice also,
but could you tell me if it would always work ?

It uses the "oid" number. I've read that it used to be unique, but within
the same session, I can assume that it is always growing, can't I ?

INSERT into A VALUES (DEFAULT, "toto");

INSERT into B VALUES (
(SELECT id FROM A WHERE oid = SELECT ( max(oid) from A)),
"toto");

--
Florence HENRY
florence point henry arobasse obspm point fr