X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 53AAE925C71 for ; Fri, 30 May 2003 12:02:13 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 28000-10 for ; Fri, 30 May 2003 12:02:10 -0400 (EDT) Received: from hotmail.com (law8-f9.law8.hotmail.com [216.33.241.9]) by developer.postgresql.org (Postfix) with ESMTP id C9C31925C61 for ; Fri, 30 May 2003 12:02:08 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 30 May 2003 09:02:08 -0700 Received: from 213.86.111.168 by lw8fd.law8.hotmail.msn.com with HTTP; Fri, 30 May 2003 16:02:07 GMT X-Originating-IP: [213.86.111.168] X-Originating-Email: [dklugmann@hotmail.com] From: "David Klugmann" To: pgsql-sql@postgresql.org Subject: SELECT statement within libpq Date: Fri, 30 May 2003 16:02:07 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 30 May 2003 16:02:08.0054 (UTC) FILETIME=[D251FD60:01C326C4] X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/569 X-Sequence-Number: 13734 Hi I'm knew to postgres and I got my first C postgres connection working from the examples in the documentation. In that it does a BEGIN and a DECLARE CURSOR FOR SELECT et.c. This seems a long way to go about getting back data each time. Is it not possible to just do a straight select and not a transaction and a cursor ? Also does anyone have any generic routines for handling results of all types of select. Many thanks David _________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail