pgsql: Re-add item with better description: > * Allow ORDER BY ... - Mailing list pgsql-committers

From momjian@svr1.postgresql.org (Bruce Momjian)
Subject pgsql: Re-add item with better description: > * Allow ORDER BY ...
Date
Msg-id 20050425130337.F0A755367D@svr1.postgresql.org
Whole thread Raw
Responses Re: pgsql: Re-add item with better description: > * Allow ORDER BY ...
List pgsql-committers
Log Message:
-----------
Re-add item with better description:

> * Allow ORDER BY ... LIMIT 1 to select high/low value without sort or
>   index using a sequential scan for highest/lowest values
>
>   Right now, if no index exists, ORDER BY ... LIMIT 1 requires we sort
>   all values to return the high/low value.  Instead The idea is to do a
>   sequential scan to find the high/low value, thus avoiding the sort.
>

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.1515 -> r1.1516)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1515&r2=1.1516)
    pgsql/doc/src/FAQ:
        TODO.html (r1.22 -> r1.23)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.22&r2=1.23)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix btree_gist to handle timetz zone correctly per recent
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: Remove item, not sure what it refers to: