Re: Request for features - filtering options.

--- On Tue, 3/2/09, Dave Page <dpage@pgadmin.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
100be possible?