Re: Return Value of a Function

Terry Lee Tucker <terry@esc1.com> writes:
> I need to return a row of data from a function. I've been looking the the HTML
> docs and have found nothing of value. If I try to return a variable of type
> RECORD, I get the following error:
> NOTICE:  plpgsql: ERROR during compile of last_log near line 0
> ERROR:  fmgr_info: function 0: cache lookup failed

What Postgres version are you running?  We used to have some bugs that
would allow unhelpful error messages like that to emerge in corner
cases.  I'm not completely sure that they're all gone.  If you're on
7.4.* I'd be interested to see exactly what you did.

> I may have several other things wrong with this function, so my real question
> is, "Can I return a value of type RECORD?"

If you know what you're doing.  The calling query has to specify a
structure for the record.

(Joe, I couldn't find a self-contained example using a function-returning-
record after a bit of searching in the 7.4 docs.  Surely there is one?)

            regards, tom lane