| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ashish Kaushal <ashish(dot)kaushal(at)getfareye(dot)com> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Getting Error while using row_number() |
| Date: | 2020-07-09 19:51:58 |
| Message-ID: | CAKFQuwbuY7Uwb28xDTtjqM8dy3-zaUKSVH3yO9eDB0SD1eQMTg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thursday, July 9, 2020, Ashish Kaushal <ashish(dot)kaushal(at)getfareye(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-07-09 19:54:21 | Re: Getting Error while using row_number() |
| Previous Message | Ashish Kaushal | 2020-07-09 19:27:10 | Getting Error while using row_number() |