Обсуждение: pgsql: Done: > * -Allow ORDER BY ...

Поиск
Список
Период
Сортировка

pgsql: Done: > * -Allow ORDER BY ...

От
momjian@postgresql.org (Bruce Momjian)
Дата:
Log Message:
-----------
Done:

> * -Allow ORDER BY ... LIMIT # to select high/low value without sort or
<
<   Right now, if no index exists, ORDER BY ... LIMIT # 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.
<   MIN/MAX already does this, but not for LIMIT > 1.
<

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.2176 -> r1.2177)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2176&r2=1.2177)
    pgsql/doc/src/FAQ:
        TODO.html (r1.677 -> r1.678)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.677&r2=1.678)