Re: [GENERAL] plpgsql: returning multiple named columns from function

2005-08-23 Thread John Lawler
Joshua D. Drake wrote: perhaps even any existing column in a table. I think what you are looking for is SetOF functions. http://www.postgresql.org/docs/8.0/interactive/functions-srf.html Thanks for the response. The reference you indicated is talking about Set Returning Functions. I'm looki

[GENERAL] plpgsql: returning multiple named columns from function *simply*

2005-08-23 Thread John Lawler
hat I'm looking to do clear. Is there any slick way of handling this that allows the column naming to occur completely within the function itself and perhaps doesn't require an external table or composite type definition? Thanks, John Lawler ---(end of broadcast)--- TIP 6: explain analyze is your friend