How to translate this query from MySQL to PostgreSQL?

Question

MySQL

There is a request:

SET @i=0;

SELECT * FROM (
SELECT *, @i:[email protected]+1 AS 'place'
 FROM test 
 ORDER BY score DESC
) t1
 WHERE id = 1;

How will it look like in PostgreSQL?

Answer 1

SELECT * FROM (
SELECT *, row_number() OVER(ORDER BY score DESC) AS 'place'
 FROM test 
 ORDER BY place
) t1
 WHERE id = 1;

?