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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html