Re: [PHP] Re: FTI, paged, ranked searching and efficiency.

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PHP] Re: FTI, paged, ranked searching and efficiency.
Дата
Msg-id 3A12C87A.390C6346@agliodbs.com
обсуждение исходный текст
Ответ на FTI, paged, ranked searching and efficiency.  (Paul <paul@operamail.com>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: FTI, paged, ranked searching and efficiency.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index problem