Re: rowtype and ecpg - Mailing list pgsql-sql

From Christoph Haller
Subject Re: rowtype and ecpg
Date
Msg-id 200206240851.KAA28147@rodos
Whole thread Raw
In response to rowtype and ecpg  (alla@sergey.com (Alla))
List pgsql-sql
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





pgsql-sql by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Select + min question
Next
From: Joseph Syjuco
Date:
Subject: assign count() result to a declared variable in plpgsql