Обсуждение: extended cursor-FETCH usage

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

extended cursor-FETCH usage

От
Daniel Péder
Дата:
is there any possibility to use output from FETCH directly to -for example- creating a new table?
Something like:

FETCH 10 FROM MyCursor     INTO     TEMP TABLE MyTempTable ( x int4, y text );

Why do I need it?

It could be sometimes faster/much effective to do this first and then do JOIN operations on table/dataset reduced this
way.

--
Dan Peder
dpeder@infoset.cz