Re: SRFs returning records from a view

AAARRRGGGHHH...  Now I understand you, Josh.  Sorry.

You are correct.

Thanks!
Mark

On Jun 1, 2005, at 4:39 PM, Joshua D. Drake wrote:

> 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/
>