Re: Atomic query and update of sequence generators

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Atomic query and update of sequence generators
Дата
Msg-id 84b4154c70a56ad7bc38057f6d5dd224@biglumber.com
обсуждение исходный текст
Ответ на Atomic query and update of sequence generators  (Jeffrey Tenny <jeffrey.tenny@comcast.net>)
Список pgsql-sql
-----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 greg@turnstep.com
PGP Key: 0x14964AC8 200401150746
                                   
 
-----BEGIN PGP SIGNATURE-----
                                
 
iD8DBQFABovdvJuQZxSWSsgRAnxeAKCWK3tFCE3u8NfXG5LG3H0smDLyhACglrr7
08ke6k8B8MSKVipRb2aSWQg=
=PSzM
-----END PGP SIGNATURE-----




В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Atomic query and update of sequence generators
Следующее
От: "Luis C. Ferreira"
Дата:
Сообщение: Re: Rule won't let me NOTIFY, no matter how hard I try