Search Postgresql Archives

Re: SRFs returning records from a view

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux