From: | David Christensen <david(at)pgguru(dot)net> |
---|---|
To: | Isaac Morland <isaac(dot)morland(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCH] GROUP BY ALL |
Date: | 2024-07-23 13:42:07 |
Message-ID: | CAHM0NXjc4Y9xdUxEu8pCwOmWKtQHKsGVb7982LQQ+Ek5qqcGig@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Jul 22, 2024 at 4:41 PM Isaac Morland <isaac(dot)morland(at)gmail(dot)com> wrote:
> And for when this might be useful, the syntax for it already exists, although a spurious error message is generated:
>
> odyssey=> select (uw_term).*, count(*) from uw_term group by uw_term;
> ERROR: column "uw_term.term_id" must appear in the GROUP BY clause or be used in an aggregate function
> LINE 1: select (uw_term).*, count(*) from uw_term group by uw_term;
> ^
This is with my patch, or existing postgres? Grouping by record is
not actually what this patch is trying to do, so perhaps there is some
ambiguity; this is intended to GROUP BY any select item that is not an
aggregate function.
From | Date | Subject | |
---|---|---|---|
Next Message | torikoshia | 2024-07-23 14:06:32 | Re: Add new COPY option REJECT_LIMIT |
Previous Message | David Christensen | 2024-07-23 13:39:20 | Re: [PATCH] GROUP BY ALL |