Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting Error while using row_number() - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Getting Error while using row_number()
Date
Msg-id CAKFQuwbuY7Uwb28xDTtjqM8dy3-zaUKSVH3yO9eDB0SD1eQMTg@mail.gmail.com
Whole thread Raw
In response to Getting Error while using row_number()  (Ashish Kaushal <ashish.kaushal@getfareye.com>)
List pgsql-bugs
Tree view
On Thursday, July 9, 2020, Ashish Kaushal <ashish.kaushal@getfareye.com> wrote:
Hi Team,

I have environment with PostgreSQL 8.0.2 on i686-pc-linux-gnu and I am trying to write sql syntax like mentioned below and getting mentioned below. 

select distinct journey_id
, ROW_NUMBER OVER (partition by `journey_id` ORDER BY journey_id)
from table_name

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  

Kindly advise asap

Don’t execute PostgreSQL queries against a MySQL Server.

David J. 

pgsql-bugs by date:

Previous
From: Ashish Kaushal
Date:
Subject: Getting Error while using row_number()
Next
From: "David G. Johnston"
Date:
Subject: Re: Getting Error while using row_number()