Re: SRFs returning records from a view

mark.lubratt@indeq.com 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/