| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Matias Montroull <matimontg(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont |
| Date: | 2021-09-24 21:04:17 |
| Message-ID: | CAKFQuwYv5JVNSOAuAW+ikF2rOAi6w=b18=5d-_QdN3BxgNixtQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, Sep 24, 2021 at 1:30 PM Matias Montroull <matimontg(at)gmail(dot)com>
wrote:
> and I'm getting an error:
> *SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate
> percentile_cont*
>
> Here's a create table statement and some sample data to reproduce the
> error:
>
> I attach some sample data to load the table
>
Well, there generally isn't much to be done about "feature not supported"
other than to change how you write the query.
That said, I don't see what the create table or the attached sql file have
to do with the query shown. You may want to try again putting together a
self-contained example.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iuri Sampaio | 2021-09-25 16:39:34 | Creating a query to structure results grouped by two columns, pivoting only a third colum |
| Previous Message | Matias Montroull | 2021-09-24 13:23:13 | SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont |