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

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

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Re-add item with better description: > * Allow ORDER BY ...
Date: 2005-04-25 13:03:37
Message-ID: 20050425130337.F0A755367D@svr1.postgresql.org (view raw or flat)
Thread:
Lists: 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)

Responses

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-04-25 13:05:47
Subject: Re: pgsql: Remove item, not sure what it refers to:
Previous:From: Tom LaneDate: 2005-04-25 07:00:32
Subject: pgsql: Fix btree_gist to handle timetz zone correctly per recent

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