Return Value of a Function - Mailing list pgsql-general

From Terry Lee Tucker
Subject Return Value of a Function
Date
Msg-id 200402020936.00754.terry@esc1.com
Whole thread Raw
Responses Re: Return Value of a Function  (Richard Huxton <dev@archonet.com>)
Re: Return Value of a Function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

I may have several other things wrong with this function, so my real question
is, "Can I return a value of type RECORD?"
--
Quote: 56
"Guard with jealous attention the public liberty. Suspect every one who
 approaches that jewel. Unfortunately, nothing will preserve it but down-
 right force. Whenever you give up that force, you are inevitably ruined."

 --Patrick Henry

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry@esc1.com

pgsql-general by date:

Previous
From: Rich Hall
Date:
Subject: Re: Problem with function
Next
From: Tom Lane
Date:
Subject: Re: Very slow query - why?