mark.lubratt@xxxxxxxxx wrote:
Hello! I have a view that I'm putting into a report in my application. I'd like to get several blank lines returned by the view as well as the legitimate data (to leave room in the report for manual entries). I thought I could make a SRF that would return the data from the view and then spit out a number of blank records. As a first step in getting my SRF feet wet, I tried: CREATE OR REPLACE FUNCTION bluecard(int4) RETURNS SETOF view_bluecard AS $BODY$declare r view_bluecard%rowtype; begin for r in select * from view_bluecard where job_id = jn loop return next r; end loop; return; end;$BODY$ LANGUAGE 'plpgsql' VOLATILE; where view_bluecard is the view that is already defined. When I try select bluecard(1130);
select * from bluecard(1130)? Sincerely, Joshua D. Drake
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
-- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
