Skip site navigation (1) Skip section navigation (2)

Re: Enhancement request - Data Grid sort controls

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Page <dpage(at)pgadmin(dot)org>
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:00:30
Message-ID: 1308236431.1945.14.camel@laptop (view raw or flat)
Thread:
Lists: pgadmin-support
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.


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


In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2011-06-16 15:03:12
Subject: Re: Enhancement request - Data Grid sort controls
Previous:From: Dave PageDate: 2011-06-16 14:50:42
Subject: Re: Enhancement request - Data Grid sort controls

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group