Yes, but I need to return n fields from one table and n fiels from another, and n fields from yet another table, etc... and return this as some kind of record... How do I to this? BTJ On Wed, 5 Jul 2006 19:13:39 +0200 Dany De Bontridder <dany@xxxxxxxxxxxxx> wrote: > On Wednesday 05 July 2006 16:46, Bjørn T Johansen wrote: > > I need to make a funtion that take one parameter and then returns a > > "record" with x number of fields, collected from x no. of tables, i.e. I > > need to run several sql statemtents to collect all the needed values from x > > no. of fields and insert it into a "record" and return the "record" at the > > end... > From http://www.postgresql.org/docs/7.4/interactive/plpgsql-declarations.html > > Example for function having return type set of record > > create function testfunc(int) returns record as ' > declare > output record; > begin > for output in select * from table1 where col1<$1 loop > return next output; > end loop; > return; > end; > ' language plpgsql > > executing through sql as: > > select * from testfunc(6) as (col1 int, col2 float, col3 char(20)); > > > Regards, > > D. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly
