-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> The main problem with this approach is that, while you get the "current
> value", the sequence is incremented by the call. I just want to
> (strictly) look at the value.
The sequence values do not change: test it for yourself.
> IF l_last_value = 0 THEN
> PERFORM setval(l_sequence_name,1, False);
> ELSE
> PERFORM setval(l_sequence_name,l_last_value);
> END IF;
Pretty good idea; just beware of sequences that do not start at 1 :)
- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200307241520
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQE/IDPUvJuQZxSWSsgRAv1MAJ9Ax8EpRTf2ElbdeN/hjMIkWSpPqwCgqAVV
Xgese545H2Qa4Znwt1Y7AlE=
=IkFq
-----END PGP SIGNATURE-----