Re: [HACKERS] question about CURSOR

2003-10-13 Thread Neil Conway
On Sun, 2003-10-12 at 05:42, ivan wrote: > Hi, How can i check how many tules has my declared cursor ? You can't know the # of tuples produced by a query without producing its entire result set. Since DECLARE doesn't actually evaluate the query you specify (... which is the whole point of using cu

[HACKERS] question about CURSOR

2003-10-12 Thread ivan
Hi, How can i check how many tules has my declared cursor ? I can set absolute position in cursor , but i dont know how far can i go ? I need it also to set size of my scroll . One more question , when i use declare cursor to show select on grid, better is to use cursor in BEGIN/END WORK, or WITH