Обсуждение: Enhancement request - Data Grid sort controls

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.

> Typically the column header indicates an order.   Clicking on the
> header  resorts the grid in the reverse order.
> 

Yeah, we have that in the server status window, but not in the data
grid.

> 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.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com

On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge
<guillaume@lelarge.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.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Thu, 2011-06-16 at 15:50 +0100, Dave Page wrote:
> On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge
> <guillaume@lelarge.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.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com

On Thu, Jun 16, 2011 at 4:00 PM, Guillaume Lelarge
<guillaume@lelarge.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@lelarge.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