From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Enhancement request - Data Grid sort controls |
Date: | 2011-06-16 15:03:12 |
Message-ID: | BANLkTim0XUsPgyYG3ebftnTTg10694c-Tw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Thu, Jun 16, 2011 at 4:00 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> On Thu, 2011-06-16 at 15:50 +0100, Dave Page wrote:
>> On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge
>> <guillaume(at)lelarge(dot)info> wrote:
>> > Hi,
>> >
>> > On Thu, 2011-06-16 at 08:54 -0500, Little, Douglas wrote:
>> >> [...]
>> >>
>> >> I’d like to request that the query data grid incorporate the column
>> >> sort controls often available in data grids.
>> >>
>> >
>> > That would be interesting.
>>
>> Unlikely to ever happen though, as we'd have to re-sort the data in
>> the PGresult structure that's used as a virtual table for the grid.
>> Avoiding that would mean copying the data into a private data
>> structure first, as we used to do in v1.2 and older (or whatever the
>> last release was before we changed that). That has a host of other
>> problems associated with it, and we're not going back to those days!
>>
>> >> Would eliminate the need to rerun the query to change order, or
>> >> cut/paste results to excel to sort.
>> >
>> > Nope, that would not change. It'll fire the query anyway, it would only
>> > change the ORDER BY clause.
>>
>> That's the Heath-Robinson approach. It would be *extremely* hard to do
>> reliably as it would have to rewrite user defined queries.
>>
>
> I thought we were talking about the edit grid, not the query tool. I may
> be wrong.
The Edit Grid already has sorting.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Shapiro | 2011-06-16 23:21:59 | Re: Is 1.14 supposed to behave differently when it loses connection? |
Previous Message | Guillaume Lelarge | 2011-06-16 15:00:30 | Re: Enhancement request - Data Grid sort controls |