row_number (genera números correlativos)

http://www.postgresqltutorial.com/postgresql-row_number/

:)  more clear water

SELECT product_id, product_name, group_id, ROW_NUMBER () OVER ( PARTITION BY group_id ORDER BY product_name ) FROM products;