From: Patrick JACQUOT <patrick.jacquot@anpe.fr>
To: pgsql-sql@postgresql.org
Subject: Re: RETURN SET OF DATA WITH CURSOR
Date: Fri, 16 Dec 2005 09:59:12 +0100
Message-ID: <43A281E0.3070403@anpe.fr> (raw)
In-Reply-To: <43A1A09D.6020708@carvalhaes.net>
References: <43A18B25.1010705@carvalhaes.net>
<43A193B4.5070206@archonet.com>
<43A1A09D.6020708@carvalhaes.net>
grupos wrote:
> Hi Richard,
>
> Thanks for your promptly answer. I don't have experience returning
> refcursor but my choice would be it.
> I read the documentation but I didn't find any example with my
> necessity...
>
> Could you give me a small example on the same "basis" that I want?
>
> Thanks,
>
> Rodrigo Carvalhaes
>
> Richard Huxton wrote:
>
>> grupos wrote:
>>
>>> Hi !
>>>
>>> I am making one plpgsql function and I need to return of setof data
>>> using a cursor.
>>>
>>> The problem is that my function is returning only the first row and
>>> column of the query. This query have more than 80 columns and 1.000
>>> rows. Enyone have any tip to give me?
>>
>>
>> Yes - decide whether you are returning a set of rows or a refcursor.
>>
>> Check the plpgsql docs again for how to return SETOF <rowtype> using
>> the RETURN NEXT statement. Then you call your function like: SELECT *
>> FROM my_func();
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
There is a standard way :
Select * from memberstatus A where not exists
(select * from emberstatus B where B.member_id=A.member_id and
B.status_date >A.status_date)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: patrick.jacquot@anpe.fr
Subject: Re: RETURN SET OF DATA WITH CURSOR
In-Reply-To: <43A281E0.3070403@anpe.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox