postgresql - Postgres 数学 : Operator does not exist: bigint == integer

Question

我有以下sql:

create table gps (laf int, "timestamp" timestamp);
select * from 
  (select *, row_number() over() from gps) as yo
where row_number == 10

但它会产生这样的响应:

ERROR: operator does not exist: bigint == integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 84

类型转换似乎没有帮助。如何将 row_number(bigint)与数字进行比较？

Answer 1

似乎我陷入了编程领域，我需要 = 而不是 ==，但在这里发布是为了后代和谷歌:

select * from 
  (select *, row_number() over() from gps) as yo
where row_number = 0