postgresql执行sql row_number() over 时报错?报错

@wenshao 你好，想跟你请教个问题：

我在postgresql里执行一个sql的时候回报错错误信息如下,麻烦你帮忙看下，多谢

SELECT res.restaurant_id,   row_number()  over (order by ST_Distance(res.restaurant_point,GeomFromEWKT(?))*111.12 )  as row_id  FROM restaurant res where res.city_id = ? and res.is_delete =false and res.restaurant_id <1000000   limit 10

com.alibaba.druid.sql.parser.ParserException: TODO OVER over, pos 46

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:226)

at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:70)

at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:41)

at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)

at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:627)

at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)