Re: Getting Error while using row_number()

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, July 9, 2020, Ashish Kaushal <ashish.kaushal@getfareye.com>
> wrote:
>> I have environment with PostgreSQL 8.0.2

> PostgreSQL 8.0.2? Seriously?

If it actually is 8.0.x, or even 8.2.x, then it lacks window functions
anyway; those came in in 8.4.  But there's a bigger problem:

>> You have an error in your SQL syntax; check the manual that corresponds to
>> your MySQL server version for the right syntax to use near '(partition by
>> `journey_id` ORDER BY `journey_id`) from `consents` limit 10' at line 6

That's not a Postgres error at all.  The OP seems quite confused.

            regards, tom lane