Select a group of numbers in sequence

[beckjoh]

I have a Postgresql table with the following structure:

id | value
----+--------
1 | 1
2 | 2
3 | 3
4 | 4
5 | 1
6 | 2
7 | 3
8 | 1
9 | 2
10 | 3
11 | 4
12 | 5

I need to group these rows by (value) numbers in sequence. So I need to query the table and return
rows with ids 1-4 in one group, rows with ids 5 -7 in another group, and rows with ids 8-12 in another group.

[Rabbit]

Left join the table to itself on the current id to the next id. Keep the one where the value in the second instance is a 1 or is a null. That will give you just the last number in each sequence. Then you just need to create a calculated column that appends the string '1-' before the current value.