extended cursor-FETCH usage - Mailing list pgsql-sql

From Daniel Péder
Subject extended cursor-FETCH usage
Date
Msg-id 01BF0A86.94B44200@Dan
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: raptor
Date:
Subject: Many questions
Next
From: "Richard Kramer"
Date:
Subject: trouble creating operators