Re: [PHP] Re: FTI, paged, ranked searching and efficiency. - Mailing list pgsql-sql

Stephen,

> How come nobody's ever thought of cursors?
>
> DECLARE foo CURSOR FOR SELECT stuff FROM stuff WHERE foo ORDER BY
> something;
>
> Hop forward N rows?
>         MOVE FORWARD $n IN foo
>
> Want M rows?
>         FETCH FORWARD $m IN foo

    I'm intrigued by this.  How would I retrieve cursor rows into a web
application?  If we could output a cursor to a functon result (we
can't), it would be easy, but I'm not sure otherwise.

                    -Josh
--
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                                San Francisco