how to sort by line number in a query in postgres?

Question

how to sort by line number in a query in postgres?

Navigation

#1 by (3 votes)

5

To populate the grid of a view I'm using the database, initially I put the table ID to be the index of the view, however when some record is deleted from the database the index does not become sequential.

html postgresql

asked by anonymous 16.11.2016 / 15:23

1 answer

Error: object of type 'closure' is not subsettable htmlspecialchars () expects parameter 1 to be string, object given

score 3 · Accepted Answer

So I understand you'd like to have a sequence of 1 to n not caring for the value of the id field.

I think it would look something like this:

SELECT
  row_number() OVER (ORDER BY id_grupo) AS ROWNUM,
  nome
FROM
  grupos;

I created a test fiddle:

link