Re: [GENERAL] retrieving parts of a resultset

2004-02-12 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Christoffer Gurell) wrote: >> I think you should use a cursor; you declare it, and then you fetch the >> rows as you need them. > > thanks this works really nice.. just one more question .. how do i check the > number of rows in a curs

Re: [GENERAL] retrieving parts of a resultset

2004-02-08 Thread Christoffer Gurell
On Fri, Feb 06, 2004 at 02:31:38PM -0300, Franco Bruno Borghesi wrote: > I think you should use a cursor; you declare it, and then you fetch the > rows as you need them. thanks this works really nice.. just one more question .. how do i check the number of rows in a cursor? or do i have to do a se

Re: [GENERAL] retrieving parts of a resultset

2004-02-06 Thread Franco Bruno Borghesi
I think you should use a cursor; you declare it, and then you fetch the rows as you need them. On Fri, 2004-02-06 at 14:04, Christoffer Gurell wrote: I want to create a program which displays large tables and makes this possible over a slow connection. The problem is that when i do a PQexec t

[GENERAL] retrieving parts of a resultset

2004-02-06 Thread Christoffer Gurell
I want to create a program which displays large tables and makes this possible over a slow connection. The problem is that when i do a PQexec the entire retultset is transfered. I would like to make pqsql process the query but only tranfer the the rows i ask for when i ask for them. This way i c