Re: connectby documentation

> -----Message d'origine-----
> De : Michael Fuhr [mailto:mike@fuhr.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.4postgresql-contrib-7.4 
(...)

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

Thanks,


--
Daniel