Re: rowtype and ecpg

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: alla(at)sergey(dot)com (Alla)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: rowtype and ecpg
Date: 2002-06-24 10:51:31
Message-ID: 200206240851.KAA28147@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marcos Garcia 2002-06-24 13:58:41 Slow SELECT with distinct, in a TIMESTAMP type column
Previous Message Denis 2002-06-24 08:28:05 Re: slow DELETE queries