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.
--
Nilesh Govindarajan
Site Server Adminstrator
www.itech7.com
--
Sent via
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
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
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
On 02/20/2010 06:51 PM, Thomas Kellerer wrote:
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
On 20/02/2010 13:08, Nilesh Govindarajan wrote:
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
On 02/20/2010 06:54 PM, Raymond O'Donnell wrote:
On 20/02/2010 13:08, Nilesh Govindarajan wrote:
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
On 20/02/2010 13:28, Nilesh Govindarajan wrote:
Okay here's my query -
select c.cid, c.subject, n.title from comments c, node n where c.nid =
n.nid and c.status != 0;
This is the query to check list of comments requiring admin approval and
also the article titles on which this is posted.
Nilesh Govindarajan wrote on 20.02.2010 14:28:
Okay here's my query -
select c.cid, c.subject, n.title from comments c, node n where c.nid =
n.nid and c.status != 0;
This is the query to check list of comments requiring admin approval and
also the article titles on which this is posted.
I
On 02/20/2010 07:12 PM, Raymond O'Donnell wrote:
On 20/02/2010 13:28, Nilesh Govindarajan wrote:
Okay here's my query -
select c.cid, c.subject, n.title from comments c, node n where c.nid =
n.nid and c.status != 0;
This is the query to check list of comments requiring admin approval and
also
On 20/02/2010 13:54, Nilesh Govindarajan wrote:
Ah perfect ! problem solved. Thanks !
Glad it was that easy! You ought to read up on set-returning functions
in the docs:
http://www.postgresql.org/docs/8.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
See the section
11 matches
Mail list logo
