| From: | Joachim Wieland <joe(at)mcknight(dot)de> |
|---|---|
| To: | andy rost <andy(dot)rost(at)noaa(dot)gov> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Using FETCH ALL with descriptor areas |
| Date: | 2006-08-01 07:39:48 |
| Message-ID: | 20060801073948.GA2236@mcknight.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
On Fri, Jul 28, 2006 at 03:35:06PM -0500, andy rost wrote:
> Is it possible, in ECPG, to use FETCH ALL with descriptor areas? If so,
> can anyone provide a simple example. If not, does anyone have a get
> around. We've found FETCH NEXT to be pretty expensive when selecting
> even a modest number of tuples.
I don't know if it is what you're looking for nor if it is faster at all but
I attach an example with descriptors and auto-allocation.
Joachim
--
Joachim Wieland joe(at)mcknight(dot)de
GPG key available
| Attachment | Content-Type | Size |
|---|---|---|
| dynalloc2.pgc | text/plain | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Steffen | 2006-08-01 21:37:23 | Re: Help with plpgsql - subst variable value |
| Previous Message | Volkan YAZICI | 2006-08-01 06:02:52 | Re: connection problem |