| From: | "Kent Anderson" <kenta(at)ezyield(dot)com> |
|---|---|
| To: | "Pgsql-Sql(at)Postgresql(dot) Org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Ordering a record returned from a stored procedure |
| Date: | 2004-10-18 15:59:09 |
| Message-ID: | LPENJIOOLAIJBFKIBDKOEELLFLAD.kenta@ezyield.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I am pulling a report from the database using a stored procedure but cannot
get the information to return in a specific order unless I hardcode the
order by clause.
CREATE OR REPLACE FUNCTION submissionreport(INTEGER, DATE, TEXT) RETURNS
setof submissionrec AS '
DECLARE
result submissionrec%rowtype;
hmhmkey ALIAS for $1;
submissiondate ALIAS for $2;
sort ALIAS for $3;
BEGIN
RAISE NOTICE ''The sort order should be: %.'', sort;
FOR result IN
SELECT
(..... select all necessary fields ...)
FROM
(.... tables ...)
WHERE
(... contraints)
ORDER BY sort
LOOP
RETURN next result;
END LOOP;
RETURN result;
END;
' LANGUAGE plpgsql;
What am I missing? The returned data is ordered if the "Order By" clause has
the values hard coded but doesn't seem to read the "sort" variable.
Any help would be appreciated.
Kent Anderson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-10-18 16:05:41 | Re: Aggregate Function with Argument |
| Previous Message | David Siegal | 2004-10-18 15:24:33 | Aggregate Function with Argument |