Re: [GENERAL] Number of items in a cursor...

2005-11-15 Thread Eric B. Ridge
On Nov 15, 2005, at 12:43 PM, Bruce Momjian wrote: Cristian Prieto wrote: Is there any way to get the numbers of items inside a cursor? I can't see a way to do it except to do a FETCH ALL and count the returned rows. What we do, via JDBC is: MOVE IN cursor_name; The JDBC drivers

Re: [GENERAL] Number of items in a cursor...

2005-11-15 Thread Bruce Momjian
Eric B. Ridge wrote: > On Nov 15, 2005, at 12:43 PM, Bruce Momjian wrote: > > > Cristian Prieto wrote: > >> Is there any way to get the numbers of items inside a cursor? > > > > I can't see a way to do it except to do a FETCH ALL and count the > > returned rows. > > What we do, via JDBC is: > >

Re: [GENERAL] Number of items in a cursor...

2005-11-15 Thread Bruce Momjian
Cristian Prieto wrote: > Is there any way to get the numbers of items inside a cursor? I can't see a way to do it except to do a FETCH ALL and count the returned rows. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001

[GENERAL] Number of items in a cursor...

2005-11-08 Thread Cristian Prieto
Is there any way to get the numbers of items inside a cursor?   ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster