X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 541509FB27F for ; Fri, 28 Jul 2006 17:35:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85231-06 for ; Fri, 28 Jul 2006 17:35:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from home.nohrsc.nws.gov (home.nohrsc.nws.gov [192.46.108.2]) by postgresql.org (Postfix) with ESMTP id CD1519FB270 for ; Fri, 28 Jul 2006 17:35:09 -0300 (ADT) Received: from noaa.gov (opps-gw.nohrsc.nws.gov [192.46.108.142]) by home.nohrsc.nws.gov (Postfix) with ESMTP id 21270A5BD for ; Fri, 28 Jul 2006 15:35:07 -0500 (CDT) Message-ID: <44CA74FA.5010305@noaa.gov> Date: Fri, 28 Jul 2006 15:35:06 -0500 From: andy rost User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Using FETCH ALL with descriptor areas Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200607/17 X-Sequence-Number: 6207 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. -- -------------------------------------------------------------------------------- Andrew Rost National Operational Hydrologic Remote Sensing Center (NOHRSC) National Weather Service, NOAA 1735 Lake Dr. West, Chanhassen, MN 55317-8582 Voice: (952)361-6610 x 234 Fax: (952)361-6634 andy.rost@noaa.gov http://www.nohrsc.noaa.gov --------------------------------------------------------------------------------