Re: Newbie DBD::Pg question

I haven't gotten into it yet but you could try using the sendQuery method
and looping on the new data as it becomes available.

Josh

On Fri, 6 Jul 2001, Mithun Bhattacharya wrote:

> Just started on postgres a few days back and was having a few questions
> about the perl interface to it. According to perldoc DBD::Pg
> ----------------
> Cursors
>
> Although PostgreSQL has a cursor concept, it has not been
> used in the current implementation. Cursors in PostgreSQL
> can only be used inside a transaction block. Because only
> one transaction block at a time is allowed, this would
> have implied the restriction, not to use any nested SELECT
> statements. Hence the execute method fetches all data at
> once into data structures located in the frontend
> application. This has to be considered when selecting
> large amounts of data !
> -----------------
> Frankly speaking I am not sure what the Author is saying here. Anybody
> cares to point me in the right direction ??? I do have to extract large
> amount of data but I am not sure whether it affects me or not.
>
>
> Mithun
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>