diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:44:05 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-09-02 05:44:05 +0000 |
| commit | 6aa4482f2f520bb06fa1016eef3960f80bf88bdf (patch) | |
| tree | e9fe2fdb9b4caf14c42d2fc8d177cf56f9366bb7 /contrib/tablefunc/tablefunc.h | |
| parent | 9fd842c4b20d55746d34a96bc6baec7d2242c2cf (diff) | |
| download | postgresql-6aa4482f2f520bb06fa1016eef3960f80bf88bdf.tar.gz postgresql-6aa4482f2f520bb06fa1016eef3960f80bf88bdf.zip | |
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
Diffstat (limited to 'contrib/tablefunc/tablefunc.h')
| -rw-r--r-- | contrib/tablefunc/tablefunc.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/contrib/tablefunc/tablefunc.h b/contrib/tablefunc/tablefunc.h index 44cfd11fcc0..3002d32f992 100644 --- a/contrib/tablefunc/tablefunc.h +++ b/contrib/tablefunc/tablefunc.h @@ -34,5 +34,6 @@ */ extern Datum normal_rand(PG_FUNCTION_ARGS); extern Datum crosstab(PG_FUNCTION_ARGS); +extern Datum connectby_text(PG_FUNCTION_ARGS); #endif /* TABLEFUNC_H */ |