| From: | Daniel Péder <dpeder(at)infoset(dot)cz> |
|---|---|
| To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Cc: | "'pgsql-hackers(at)postgres(dot)org'" <pgsql-hackers(at)postgres(dot)org> |
| Subject: | extended cursor-FETCH usage |
| Date: | 1999-09-29 13:26:11 |
| Message-ID: | 01BF0A86.94B44200@Dan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)infoset(dot)cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 1999-09-29 13:44:37 | Re: [SQL] How about a postgreSQL cookbook? (was [SQL] Subselect performance) |
| Previous Message | Stuart Rison | 1999-09-29 09:06:51 | [SQL] How about a postgreSQL cookbook? (was [SQL] Subselect performance) |