Skip some ranges in postgresql sequence?

Question

I want to skip some ranges in sequence:

Create sequence id_seq;

Consider I have a sequence as Id_seq.. And it starts from 100..

When it reaches to 199.. Then it should start with 1000 and when it reaches 1999 .. It should start with 10000..

setval(100,'Id_seq');

Whether postgres has any default configuration to do this?

Multiple process will use this sequence.. So assigning manually in process using setval() lead some difficulties..

Richard Huxton · Accepted Answer · 2017-01-16 12:13:42Z

2

No there is nothing built in to do this. I've never heard of anyone wanting to do this before.

If you really care about the numbers you get then a sequence isn't the right thing for you anyway. You can get gaps in it quite easily. It's designed to generate differing numbers without impacting concurrency.

answered Jan 16, 2017 at 12:13

Richard Huxton

23.5k5 gold badges42 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Skip some ranges in postgresql sequence?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related