Postgres math: 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