Thread: pgsql-server/contrib/tablefunc README.tablefun ...
pgsql-server/contrib/tablefunc README.tablefun ...
From
momjian@postgresql.org (Bruce Momjian - CVS)
Date:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: momjian@postgresql.org 02/09/02 01:44:05 Modified files: contrib/tablefunc: README.tablefunc tablefunc-test.sql tablefunc.c tablefunc.h tablefunc.sql.in Log message: 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