Getting Error while using row_number()

From: Ashish Kaushal <ashish(dot)kaushal(at)getfareye(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Getting Error while using row_number()
Date: 2020-07-09 19:27:10
Message-ID: CAF9kNtEa1rnGv6sr3eXm00ChptCW+zuuNeZ9d6Zio4tfJVKX_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Thanks
Ashish Kaushal
8285877270

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2020-07-09 19:51:58 Re: Getting Error while using row_number()
Previous Message Soumyadeep Chakraborty 2020-07-09 17:56:10 Re: posgres 12 bug (partitioned table)