Re: reorder GROUP BY list - Mailing list pgsql-patches

From Neil Conway
Subject Re: reorder GROUP BY list
Date
Msg-id 1141535074.24513.64.camel@localhost.localdomain
Whole thread Raw
In response to Re: reorder GROUP BY list  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: reorder GROUP BY list
List pgsql-patches
On Sat, 2006-03-04 at 21:21 -0500, Tom Lane wrote:
> 1. For each ORDER BY item:
>     1a. Find a matching GROUP BY item.
>         (Break out of loop if no match.)
>     1b. Add it to the output list with ORDER BY item's ordering op.
>     1c. Remove the matched item from the GROUP BY list.
> 2. For each remaining GROUP BY item:
>     2a. Add it to output list using default ordering op.

Okay, attached is a revised patch that implements this. Barring any
objections I'll apply it tomorrow.

-Neil


Attachment

pgsql-patches by date:

Previous
From: "Sergey E. Koposov"
Date:
Subject: fix of some issues with multi-line query editing
Next
From: Bruce Momjian
Date:
Subject: Re: TODO-Item: include for guc