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