Actually, it looks like currval is defined to give the
value last used in your session. So, the second case
(not in transaction) should still always give the
value of the last nextval, assuming they're part of
the same session.
Stephan Szabo
[EMAIL PROTECTED]
On Thu, 21 Sep 2000, Edward Q. B
actually they're saying two different things :)
first, to explain my example a bit better:
the difference between this:
> > begin;
> > insert into foo (A,B) values (B);
> > select currval('foo_A_seq');
> > commit;
and this:
> > insert into foo (A,B) values (B);
> > select currval('foo_A
