Re: Return Value of a Function

On Monday 02 February 2004 14:36, Terry Lee Tucker wrote:
>
> I may have several other things wrong with this function, so my real
> question is, "Can I return a value of type RECORD?"

Yes, but you can't necessarily do anything with it (unless you're calling it
from another function).

You could return a SETOF myrowtype where the set contains only one row -
that's probably what you're after. Then you can do things like:

SELECT * FROM set_returning_function(1,'a');

--
  Richard Huxton
  Archonet Ltd