Re: connectby documentation

> -----Message d'origine-----
> De : Michael Fuhr [mailto:mike(at)fuhr(dot)org]
> Envoyé : lundi, mars 13, 2006 11:12
> À : Daniel Caune
> Cc : postgresql sql list
> Objet : Re: [SQL] connectby documentation
>
> On Mon, Mar 13, 2006 at 10:37:37AM -0500, Daniel Caune wrote:
> > I'm searching for an Oracle START WITH ... CONNECT BY PRIOR ...
> > equivalence. It seems that PostgreSQL (version >= 7.4) supports a
> > function connectby that provides similar feature. Unfortunately I don't
> > find any documentation on that function. Could you please give me a
> > link on such documentation?
>
> connectby() is part of the contrib/tablefunc module. You'll need
> to install that module and load it into your database.
>
> Somebody has made a CONNECT BY patch but the developers have objected
> to it for various reasons. Search the list archives for discussion.
>

That sounds good. I tried to install PostgreSQL contrib modules on my Linux/Debian distribution:

> apt-get install postgresql-contrib

(...)
The following extra packages will be installed:
libpq3 libxml2 postgresql postgresql-7.4 postgresql-client postgresql-client-7.4 postgresql-contrib-7.4
(...)

7.4?! Huh... Is there any sources.list a bit more updated? Where can I download PostgreSQL contrib modules. The documentation 8.1 doesn't help so much. Where can I find more documentation on available contrib. modules?

Thanks,

--
Daniel