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 E29A99FB252 for ; Wed, 2 Aug 2006 08:18:19 -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 30442-04 for ; Wed, 2 Aug 2006 08:18:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id E58E29FB24F for ; Wed, 2 Aug 2006 08:18:11 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id b36so29097pyb for ; Wed, 02 Aug 2006 04:18:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ejbKj36h09osjsKLWbLQG3VbU7wn2M4UJrNFXxJXSPFBicyQpWGkT6ziJRX68ujlixj14VZbnEdb22B2jko4EzHkQp14Rt+rrWnXzAxu9c5LSixI/HsVd38JLa0EgTfVi8srtL8FJPUa+OMoETDSKToluNmj48iCycQ+CF+JBK4= Received: by 10.35.57.5 with SMTP id j5mr1276112pyk; Wed, 02 Aug 2006 04:18:06 -0700 (PDT) Received: by 10.35.117.2 with HTTP; Wed, 2 Aug 2006 04:18:06 -0700 (PDT) Message-ID: Date: Wed, 2 Aug 2006 13:18:06 +0200 From: Andro To: pgsql-interfaces@postgresql.org Subject: [libpq] columns binding? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/4 X-Sequence-Number: 6218 Hi, a while ago, a couple of threads talked about columns binding since having to copy and convert the data out of libpq allocated PGresult* into our own objects is quite inconvenient and could turn out to be expensive as manipulating large amount of data. Has there been any changes regarding libpq data retrieval method? I've been looking into libpq API for a while now but I couldn't find anything related to column binding. I guess the "resultset" method is the only one, and that dramatically implies having data two times in memory in case of developing a (database generic) API - using bindings - on top of libpq. Is it really the only way of proceeding? Thanks for help Charles