Postgres math: Operator does not exist: bigint == integer

Question

I have the following sql:

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

But it yields this response:

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

typecasting does not seem to help. How do I compare row_number (a bigint) with a number?

rogerdpack · Accepted Answer · 2021-10-22 17:16:33Z

7

Seems I'm stuck in programming land, I needed = instead of ==, but posting here for posterity, and google:

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

answered Oct 22, 2021 at 17:16

rogerdpack

67.7k40 gold badges290 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres math: Operator does not exist: bigint == integer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related