[EMAIL PROTECTED] wrote: > Hi everybody, > > I'm a PG newbie, and I'm trying to write a function that returns a > set of records. > These records come from 2 or more tables (joined). > > When I have only 1 table, the return type of the function can be SETOF > mytable. > When I have 2 tables or more, am I obliged to create a type (CREATE > TYPE) so that my function can return a SETOF mytype? > > This works fine, but I'm trying to avoid building a specific type for > each row returning function. > Is there any other solution (SQL or PLPGSQL)?
Yes, return setof record, look at this site, it helped me a lot. http://techdocs.postgresql.org/guides/SetReturningFunctions --- Miguel ---------------------------(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
