Re: dynamic OUT parameters? - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: dynamic OUT parameters?
Date
Msg-id 162867790902010331q1a65468ewfaadb801e872b30c@mail.gmail.com
Whole thread Raw
In response to Re: dynamic OUT parameters?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-sql
Hello

try to look on

http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html

regards
Pavel Stehule

2009/2/1 Ivan Sergio Borgonovo <mail@webthatworks.it>:
> On Sun, 01 Feb 2009 12:42:12 +0900
> Craig Ringer <craig@postnewspapers.com.au> wrote:
>
>> gherzig@fmed.uba.ar wrote:
>>
>> > Well, aparenty my problem remains, because the boss want that the
>> > programmers just need to call
>> > select * from report('table_name').
>>
>> Then, AFAIK, you're not going to have much luck, as Pg needs to
>> know the columns that'll be output before the function is called.
>> Applications and DB access interfaces also usually also need to
>> know the column list beforehand.
>>
>> If you return a refcursor you can at least use:
>>
>> SELECT report('table_name');
>> FETCH ALL IN 'cursorname';
>>
>> The documentation has a more full example:
>>
>> http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html#AEN40465
>>
>> Personally, I find it difficult to imagine what could be wrong
>> with that.
>
> I've followed this thread with interest.
> I'm starting to manage larger and larger code base of plpsql.
> What I find hard to achieve is code reuse and implication of some
> techniques to performances.
>
> I didn't see many examples that exploit cursors around.
> Does anyone have some pointer to some more enlightening use of
> cursors for code reuse and OOP?
>
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>


pgsql-sql by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: dynamic OUT parameters?
Next
From: "Bart Degryse"
Date:
Subject: Re: regexp_replace and UTF8