| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | david(at)daily-harvest(dot)com |
| Subject: | BUG #15143: Window Functions – Paranthese not allowed before OVER term |
| Date: | 2018-04-04 23:41:48 |
| Message-ID: | 152288530821.1433.12335727835614659957@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15143
Logged by: David
Email address: david(at)daily-harvest(dot)com
PostgreSQL version: 9.6.6
Operating system: Mac / DBeaver
Description:
```SELECT *,
(P2.received_at - LAG(P2.received_at)) OVER (PARTITION BY anonymous_id ORDER
BY P2.received_at DESC) AS time_diff
--((EXTRACT(EPOCH FROM (P2.received_at - LEAD(P2.received_at)))/60)) OVER
(PARTITION BY P2.anonymous_id ORDER BY P2.received_at DESC) AS
time_diff_minutes
FROM javascript.pages P2```
For the second line, I have to remove the parentheses around (P2.received_at
- LAG(P2.received_at)) for it to run. Which doesn't make sense. And more
importantly, I can't seem to get the 3rd line (currently commented out) to
run because of this issue of Postgres seeming to not allow parentheses
before the OVER
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2018-04-05 00:23:21 | Re: BUG #15143: Window Functions – Paranthese not allowed before OVER term |
| Previous Message | Tom Lane | 2018-04-04 18:50:12 | Re: BUG #14999: pg_rewind corrupts control file global/pg_control |