Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 254C99F99FC for ; Sat, 25 Aug 2007 06:21:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19666-08 for ; Sat, 25 Aug 2007 06:21:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 6973A9F9B57 for ; Sat, 25 Aug 2007 06:21:45 -0300 (ADT) Received: from feivel (p54BBE039.dip.t-dialin.net [84.187.224.57]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 06F55776C4; Sat, 25 Aug 2007 11:15:18 +0200 (CEST) Received: by feivel (Postfix, from userid 1000) id B3672D6D3C; Sat, 25 Aug 2007 11:21:41 +0200 (CEST) Date: Sat, 25 Aug 2007 11:21:41 +0200 From: Michael Meskes To: Roger Moloney Cc: pgsql-interfaces@postgresql.org Subject: Re: ecpg: HOW TO READ RECORD ?? Message-ID: <20070825092141.GA16916@feivel.credativ.de> Mail-Followup-To: Roger Moloney , pgsql-interfaces@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/13 X-Sequence-Number: 6607 On Thu, Aug 23, 2007 at 02:55:10PM +0000, Roger Moloney wrote: > I'm having trouble trying to get embedded SQL to read the result of a > plpgsql function which returns RECORD or SETOF RECORD. > ... > WHAT SHOULD THE ECPG PROGRAM LOOK LIKE THAT CAN READ THE DATA RETURNED ? Any reason to shout? :-) You call that function with a select, right? So where's the difference between the handling of a "normal" select that returns more than one tuple (e.g. in preproc/define.pgc) and yours? Or what am I misunderstanding here? Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!