Обсуждение: rowtype and ecpg

Поиск
Список
Период
Сортировка

rowtype and ecpg

От
alla@sergey.com (Alla)
Дата:
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


Re: rowtype and ecpg

От
Christoph Haller
Дата:
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





Re: rowtype and ecpg

От
alla@sergey.com (Alla)
Дата:
My problem is a "rowtype" variable. 

I don't know how to declare a structure or anything else to pass
information to the function, which input parameter has a type of
"rowtype" (I have no problem retrieving any output - varchar or
refcursor)

Thanks

Alla