PostgresV2 and bulk resultsets

> Hi,
>
> if I call:
> conn execute: 'select * from one_milion_table'
> it seems that all table rows are loaded into memory - right?
>
> Is there an easy way to only iterate (do:) result set records without
> internal loading bulky resultset into some sort of internal arrays?
>
> Thanks, pf
> ------------------------------------------------------------------------
>
> _______________________________________________
> Beginners mailing list
> [hidden email]
> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>  

> OK. I implemented this functionality. Look at comment in method:
> PGConnection>>execute: sqlString withRowBlock: aRowBlock
>
> Is possible to add attached changesets to PostgresV2 package? (by  Yanni
> Chiu)
>
> Thanks, pf
>
> On 27.11.2007, at 17:01, Franz Josef Konrad wrote:
>
>> This should help you...
>> <http://article.gmane.org/gmane.comp.lang.smalltalk.squeak.general/109157 
>> >
>> I don't know if there is an API in newer versions from Postgresql  
>> where you can query the number in the result set.
>>
>> Regards,
>> Franz Josef
>>
>> Petr Fischer schrieb:
>>
>>> Hi,
>>>
>>> if I call:
>>> conn execute: 'select * from one_milion_table'
>>> it seems that all table rows are loaded into memory - right?
>>>
>>> Is there an easy way to only iterate (do:) result set records  
>>> without internal loading bulky resultset into some sort of internal  
>>> arrays?
>>>
>>> Thanks, pf
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Beginners mailing list
>>> [hidden email]
>>> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>>>
>>
>> _______________________________________________
>> Beginners mailing list
>> [hidden email]
>> http://lists.squeakfoundation.org/mailman/listinfo/beginners
>>
>