Re: connectby documentation

> > > Sorry, this is not my day: "apt-get install
postgresql-contrib-8.1"
> > > works fine... Just a link on the documentation that fully
explains
> how
> > > connectby() works would be great! :-)
> >
> > The contrib package should have installed a file named
> README.tablefunc.
> >
>
> You are right. The documentation is located in
> /usr/share/doc/postgresql-contrib-8.1/ .
>
> Wow, that was the quest for the Holy Grail! :-)
>

Huh... It seems that installing the package postgresql-contrib does not
make the work itself.

I provide hereafter a description about how to install the function
connectby (I didn't find such documentation and I don't know where to
write this documentation):

> apt-get install postgresql-contrib-8.1
> emacs /usr/share/postgresql/8.1/contrib/tablefunc.sql

Replace "$libdir" by "/usr/lib/postgresql/8.1/lib/tablefunc.so" (I
suggest to modifying only a copy of this file).

> su postgres
> psql -f /usr/share/postgresql/8.1/contrib/tablefunc.sql <database>

You can check that the work is done as follows:

> psql <database>

<database> => \df connectby
List of functions
Schema | Name | Result data type | Argument data types

--------+-----------+------------------+--------------------------------
-------------
public | connectby | setof record | text, text, text, text, integer
public | connectby | setof record | text, text, text, text,
integer, text
public | connectby | setof record | text, text, text, text, text,
integer, text

I hope that will help another PostgreSQL newbie.

--
Daniel