Scrolling cursors in PL/PgSQL

Поиск
Список
Период
Сортировка
От Dawid Kuroczko
Тема Scrolling cursors in PL/PgSQL
Дата
Msg-id 758d5e7f0711011319t5e752dsad6481d1427a46ff@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Scrolling cursors in PL/PgSQL
Re: [GENERAL] Scrolling cursors in PL/PgSQL
Список pgsql-sql
Hello.

Is there a way to scroll a cursor from within PL/PgSQL?

I tried EXECUTE, but:

ERROR:  cannot manipulate cursors directly in PL/pgSQL
HINT:  Use PL/pgSQL's cursor features instead.

The idea would be that PL/pgsql function would look
through (all) query results, then rewind the cursor and
finally return it.

My fellow developers have created a function which run
the (complex) query twice (first a count(*) on the result
set, then return the row count and cursor to the results.
Then they created a version which uses temporary
table as a placeholder for the query results, and results
count and a pointer to select * from tmp_table.

Now I imagined a function which would open the cursor,
MOVE FORWARD ALL, then MOVE ABSOLUTE 0;
and return count and a cursor, yet it seems it won't work.

Any other idea how to efficiently solve such a problem?

   Regards,
     Dawid

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Backup Database
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: [GENERAL] Scrolling cursors in PL/PgSQL