Re: Procedures

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Procedures
Date: 2010-02-20 13:21:20
Message-ID: hlonka$9iv$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nilesh Govindarajan wrote on 20.02.2010 14:08:
> On 02/20/2010 02:32 PM, John R Pierce wrote:
>> Nilesh Govindarajan wrote:
>>> How do I create a procedure using plpgsql cursors to print the output
>>> of the query in the cursor (using for loop) ?
>>>
>>> In all docs I found, it seems to be a must to return data to the call
>>> which is not what I want.
>>>
>>
>> what is it going to print it on? the postgres server processes have no
>> console or stdout device.
>
> Okay, so how do I print it to stdout ?
>
Even if you could, that would be stdout of the *server*, not the one of the client calling the procedure!

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nilesh Govindarajan 2010-02-20 13:23:51 Re: Procedures
Previous Message Nilesh Govindarajan 2010-02-20 13:08:14 Re: Procedures