Stored Procedures returning a RECORD

From: "Kent Anderson" <kenta(at)ezyield(dot)com>
To: "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org>
Subject: Stored Procedures returning a RECORD
Date: 2004-10-05 17:52:53
Message-ID: LPENJIOOLAIJBFKIBDKOOECKFBAD.kenta@ezyield.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am attempting to use a stored procedure to pull a report from the
database. My questions is if its even possible to pull the data using a
function and then treat the returned data as a normal recordset with the web
pages.

The actual function looks like

CREATE OR REPLACE FUNCTION submissionreport(integer, date, text) RETURNS
RECORD AS'

DECLARE
somekey ALIAS for $1;
somedate ALIAS for $2;
somesortorder ALIAS for $3;
submission RECORD;
BEGIN

SELECT INTO submission (... stuff goes here)
ORDER BY sort;

RETURN submission;
END;
' LANGUAGE plpgsql;

The error being returned is in the web pages"
SQLState: 08S01 Native Error Code: 1 Error while executing the query;
ERROR: cannot display a value of type record"

Kent Anderson
EZYield.com
407-629-0900
www.ezyield.com

========================================
This electronic message transmission contains information from the Company
that may be proprietary, confidential and/or privileged. The information is
intended only for the use of the individual(s) or entity named above. If
you are not the intended recipient, be aware that any disclosure, copying or
distribution or use of the contents of this information is prohibited. If
you have received this electronic transmission in error, please notify the
sender immediately by replying to the address listed in the "From:" field.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2004-10-05 20:41:58 Re: Stored Procedures returning a RECORD
Previous Message Michael Fuhr 2004-10-05 16:19:12 Re: Using timestamp in function