Attached is an update to contrib/tablefunc. It introduces a new

Bruce Momjian <bruce@momjian.us>

Commit: 6aa4482f2f520bb06fa1016eef3960f80bf88bdf
Author: Bruce Momjian <bruce@momjian.us>
Date: 2002-09-02T05:44:05Z
Releases: 7.3.1
Attached is an update to contrib/tablefunc. It introduces a new
function, connectby(), which can serve as a reference implementation for

the changes made in the last few days -- namely the ability of a
function to return an entire tuplestore, and the ability of a function
to make use of the query provided "expected" tuple description.

Description:

   connectby(text relname, text keyid_fld, text parent_keyid_fld,
     text start_with, int max_depth [, text branch_delim])
   - returns keyid, parent_keyid, level, and an optional branch string
   - requires anonymous composite type syntax in the FROM clause. See
     the instructions in the documentation below.

Joe Conway

Files