From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Guyren Howe <guyren(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: FIRST_VALUE argument must appear in group by? |
Date: | 2016-05-17 18:03:14 |
Message-ID: | CAKFQuwZZtatL-S=XUgMbGA1RExqTQZZ6SaG3B_bKSd4WatSFcQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 17, 2016 at 1:36 PM, Guyren Howe <guyren(at)gmail(dot)com> wrote:
> I am trying to use a window function, but it's not working. The subquery
> is effectively aggregating.
>
>
I would advise avoiding using select-list scalar (and particularly
correlated) subqueries when the query level in question also contains a
group by. Do the group by in a subquery and then in the parent query pull
in whatever subselects you want to execute.
You need to make it easier for people to help. The first post you sent was
just a window function. I asked for
detail and you sent a query without one. Given that discrepancy, added to
the fact the query is question is not self-contained, I am less than
inclined to try and figure out what you are trying to do.
Given me a query that has a window function and looks like, if said window
function was removed, it would successfully run, and I'll made an educated
guess.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-05-17 18:07:46 | Re: FIRST_VALUE argument must appear in group by? |
Previous Message | Raymond O'Donnell | 2016-05-17 17:54:33 | Re: Thoughts on "Love Your Database" |