Postgres Pro
Downloads
Home   >   mailing lists

PL/PGSQL CURSOR looping/iteration - PG 8.3 - Mailing list pgsql-general

From
Subject PL/PGSQL CURSOR looping/iteration - PG 8.3
Date
Msg-id 1865C9721FF546CB9BCF5304BE8C078A@nc05072019
Whole thread Raw
In response to Understanding 8.4 new WITH syntax  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: PL/PGSQL CURSOR looping/iteration - PG 8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

I see some proposal for implementing FOR loop for cursor in PG 8.4, but I could not found documentaion on how to loop or iterate thru a cursor in PG 8.3 or earler versions?
 
I guess I could do a FOR loop if I know the size of a cursor? How to find the size of a cursor?
 
Thanks,
CYW

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Understanding 8.4 new WITH syntax
Next
From: Tom Lane
Date:
Subject: Re: PL/PGSQL CURSOR looping/iteration - PG 8.3