I have a simple table with a primary id column called id.
I have a need to ALTER the table and delete the primary id column. When I do the first 6 rows are reordered to the bottom of the table. I do not want them to be reordered. Any thoughts? Thanks in advance.
beckjoh
Last Activity: Sep 29 '14, 11:23 PM
Joined: Sep 26 '14
Location:
-
Table rows are reordering after I delete a primary key column
-
Select a group of numbers in sequence
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...
No activity results to display