Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id C7C18475E39
	for <pgsql-sql@postgresql.org>; Mon, 24 Jun 2002 08:24:04 -0400 (EDT)
Mailbox-Line: From ch@rodos.fzk.de  Mon Jun 24 08:24:04 2002
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id 39024475ACE
	for <pgsql-sql@postgresql.org>; Mon, 24 Jun 2002 04:51:36 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Mon Jun 24 10:51:33 2002 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA16830; Mon, 24 Jun 2002 10:51:32 +0200 (METDST)
From: Christoph Haller <ch@rodos.fzk.de>
Message-Id: <200206240851.KAA28147@rodos>
Subject: Re: rowtype and ecpg
To: alla@sergey.com (Alla)
Date: Mon, 24 Jun 2002 10:51:31 METDST
Cc: pgsql-sql@postgresql.org
In-Reply-To: <9275d56e.0206200915.988c67d@posting.google.com>;
	from "Alla" at Jun 21, 102 6:55 pm
X-Mailer: Elm [revision: 212.4]
X-Spam-Status: No, hits=-2.9 required=5.0 tests=IN_REP_TO,INVALID_DATE
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200206/318
X-Sequence-Number: 8283

What exactly is your problem? 
Calling a plpgsql function from within a C program 
or retrieving varchar data within a C program? 
Regards, Christoph 

> 
> I have a function that takes as a parameter ROWTYPE:
> 
> create or replace function test_func(test_table) 
> returns varchar as '
> declare
>    lv_return   varchar;
> begin
>    ......
>    return lv_return;
> end;
> ' LANGUAGE 'plpgsql';
> 
> How do I call this function from the C program (ecpg)? How my
> declaration should look like?
> 
> I trued structure and got error: Too many arguments
> 
> Thanks for your help