I had asked something simular a week back. This should help you :-) http://fts.postgresql.org/db/mw/msg.html?mid=121203 cheers, thalis ps did someone play too much with the majordomo? it screwes up the list addresses in Cc: when I reply to a message On 12 Jun 2001, Alla wrote: > Guys; > > I am begging for your help again. > > I can't find a solution to my problem. > > I am porting a complex system from Oracle to PostgreSQL and I need to > implement the following: > > function 1 does some processing and returns a record (I can declare it > as a row in a view) > function 2 uses func1 to get that record and does some more processing > > My problem is that even if I can return a record from my function 1, > function 2 does not read it properly > > Here is an example: > create view my_view > as select null as type, null as value, null as timestamp; -- this > is how I "declare" the user-defined data structure (I could not find > any other way) > > create function func1() > returns my_view as ' > declare > my_record my_view%rowtype; > begin > ..... > ..... > my_record.type := ''AAA''; > my_record.value := 25; > my_record.timestamp := now(); -- this is for simplicity > > return my_record; > end; > ' LANGUAGE 'plpgsql'; > > create function func2() > returns varchar as ' > declare > my_record my_view%rowtype; > begin > select func1() into my_record; > > return my_record.type; > end; > ' LANGUAGE 'plpgsql'; > > > It compiles and runs fine, except that it does not return what it's > supposed to. It gives me some strange huge number, which I assume is > some kind of OID > > > I know that there are quite a few gurus of PostgreSQL out there - > please help me solve this problem. May be my whole approach is wrong, > but I need to be able 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 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
