| From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Return Value of a Function |
| Date: | 2004-02-02 14:36:00 |
| Message-ID: | 200402020936.00754.terry@esc1.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)esc1(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-02 14:53:50 | Re: Very slow query - why? |
| Previous Message | Rich Hall | 2004-02-02 14:20:52 | Re: Problem with function |