[SQL] Please help! Functions passing records between them

2001-06-12 Thread Alla
e to accomplist this: pass some kind of user-defined structures between function Thank you so much for your help Alla Gribov ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Function returning record

2001-06-12 Thread Alla
to execute this at all); ERROR: fmgr_info: function 0: cache lookup failed Please help. Thanks a lot in advance Alla ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] rowtype and ecpg

2002-06-21 Thread 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 sh

Re: [SQL] rowtype and ecpg

2002-06-25 Thread 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 -