I have a list of positions:
pos 123 100024 1025 5426
I want to define a range of these positions
So when i do a Select of how many positions there are in that range counts the number of elements in the range.
I've tried with:
SELECT pos , generate_seres(max(pos)::int, min(pos)::int, 1000::int) as pos_int FROM varianti group by pos ORDER BY pos;
But i don't think that is correct...
Is there a way?