Christoffer Gurell wrote:
> After declaring a cursor. Is there any way you can check the number of rows
> that cursor contains ??
test=> BEGIN;
BEGIN
test=> DECLARE xxx CURSOR FOR SELECT * FROM pg_class;
DECLARE CURSOR
test=> MOVE ALL IN xxx;
MOVE 184
Yes, you can MOVE ALL in the cursor and look at the return status, in
this case 184 rows.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073