"David Fetter" <[EMAIL PROTECTED]> writes:
> On Mon, May 19, 2008 at 12:21:20AM -0400, Gregory Stark wrote:
>> "Zoltan Boszormenyi" <[EMAIL PROTECTED]> writes:
>> > Also, it seems there are no infinite recursion detection:
>> > # with recursive x(level, parent, child) as (
>> > select 1::integer, * from test_connect_by where parent is null
>> > union all
>> > select x.level + 1, base.* from test_connect_by as base, x where
>> > base.child
>> > = x.child
>> > ) select * from x;
>> > ... it waits and waits and waits ...
>> Well, psql might wait and wait but it's actually receiving rows. A
>> cleverer client should be able to deal with infinite streams of
> That would be a very good thing for libpq (and its descendants) to
> have :)
I think you can do it in libpq.
In psql you can use \set FETCH_COUNT or somrthing like this (I can't look it
up just now) to use a cursor to do this too.
Ask me about EnterpriseDB's 24x7 Postgres support!
Sent via pgsql-patches mailing list (firstname.lastname@example.org)
To make changes to your subscription: