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