SQL row_number in PostgreSQL below 8.3

Asked Dec 23 '15 at 05:22

Active Aug 01 '18 at 05:38

Viewed 101 times

Since row_number can't used to

How can I get a row like

SELECT ROW_NUMBER() OVER() FROM table

edited Aug 01 '18 at 05:38

Cœur

asked Dec 23 '15 at 05:22

zHepHirotHz

`SELECT ROW_NUMBER() OVER(),*FROM table` ?? and `SELECT ROW_NUMBER() OVER() FROM table` this will also yields result if you've rows in that table,BTW what you're trying to get ?? – Vivek S. Dec 23 '15 at 05:23
your question is not clear, explain it properly. – Chiragkumar Thakar Dec 23 '15 at 06:03
The duplicate claims to be about `rank` but the answers cover `row_number` too. – mu is too short Dec 23 '15 at 06:13
8.3 is long out of support. You should upgrade to a maintained version **now**. – Dec 23 '15 at 07:19
Thanks for everyone. Finally I can find a solution CREATE TEMP SEQUENCE foo; SELECT nextval('foo') can fix this issues – zHepHirotHz Dec 24 '15 at 06:59

0 Answers0