-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
                                                                                       
                                      
                                                                                       
                                      
> The goal is to get a sequence of 20 values that are
> all +1 from each other.
                                                                                       
                                      
If you don't care about the rest of the values being +1
from each other, you could create the sequence with an
INTERVAL of 20. Other than that, you would probably have
to create your own "sequence" generator. Another
alternative would be a function like this:
                                                                                       
                                      
get nextval as x
set sequence to x+20
get nextval as y
repeat if y != x+20 (i.e. someone else grabbed a value)
                                                                                       
                                      
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200401150746
                                                                                       
                                      
-----BEGIN PGP SIGNATURE-----
                                                                                       
                                      
iD8DBQFABovdvJuQZxSWSsgRAnxeAKCWK3tFCE3u8NfXG5LG3H0smDLyhACglrr7
08ke6k8B8MSKVipRb2aSWQg=
=PSzM
-----END PGP SIGNATURE-----



---------------------------(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

Reply via email to