"Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com> writes:
> Thanks for the input. This looks very promising. I have one further
> question. My SQL statement is going to pull data from more than one
> table in a relatively complex query. How do I cast the RETURNS portion
> of the function?
In current releases, you'll have to create a named composite type that
matches what you want to return, and declare the function as returning
that type.
(PG 8.1 will have a facility for named OUT parameters that lets you
avoid the notational overhead of inventing a composite type, although
what happens under-the-hood is not really very different.)
regards, tom lane