Re: Recursive request ... - Mailing list pgsql-sql

From Joe Conway
Subject Re: Recursive request ...
Date
Msg-id 3F0D1977.5060300@joeconway.com
Whole thread Raw
In response to Recursive request ...  (Benoît Bournon <benoit.bournon@adelis.com>)
List pgsql-sql
Benoît Bournon wrote:
> I have to make a function that returns a tree with title and link of a 
> table.
> 
> Recursively, a information depends on a parent information.
> 
> It is to organise a menu with parent dependance.
> 
> How is it possible and faster  ? in C ? pl/pgsql or other ?
> 

On 7.3 and later: see contrib/tablefunc. The function is called connectby().

HTH,

Joe



pgsql-sql by date:

Previous
From: "listrec"
Date:
Subject: Re: Datatype conversion help
Next
From: "David Witham"
Date:
Subject: Re: trigger proceedures in sql