postgresql row_number()产生的行号是按新表/新视图生成的,还是从基础表里直接取出来的?
select row_number() over() as rownum,* from tbl3 order by ts desc limit 100;
上面这条语句的rownum从1开始生成
select row_number() over() as rownum,* from tbl3 order by ts desc limit 10;
而这条语句的rownum则是直接从表tbl3里取出来的。