"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 >> records. > > 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. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
