Re: Request for features - filtering options.

--- On Tue, 3/2/09, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> > Hello,
> >
> > I am not a subscriber of mailing list so maybe such
> idea was
> > already presented.
> >
> > It would be nice to see (for me) 2 features in
> pgAdmin:
> >
> > 1. Table -> View data -> new option: View
> Bottom 100 Rows which would be
> > useful in case of checking last changes - otherwise I
> have view to Top 100
> > and change ordering
>
> The Top 100 option simply shows the first rows in the
> arbitrary order
> that the server reads them. 'Bottom 100' is
> meaningless without a
> defined order which would obviously be table-specific. At
> best it
> would mean 'the last 100 rows read from disk' but
> to get those, we'd
> need to get all the preceding ones first which makes it
> pointless
> limiting the size of the dataset in the first place.
>

I see. It'd be nice if there could be some sort of option "order top 100 by primary key" - then perhaps would the last 100 be possible?