X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id A8C29DF6E9 for ; Fri, 11 Jul 2003 07:42:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 49390-07 for ; Fri, 11 Jul 2003 04:42:39 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id CDA08CD2C6 for ; Thu, 10 Jul 2003 10:31:19 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 7670310248; Thu, 10 Jul 2003 09:24:44 -0400 (EDT) Received: from [10.0.2.7] (unknown [10.0.2.7]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 6A02010258; Thu, 10 Jul 2003 09:24:42 -0400 (EDT) Subject: Re: Recursive request ... From: Rod Taylor To: =?ISO-8859-1?Q?Beno=EEt?= Bournon Cc: pgsql-sql@postgresql.org In-Reply-To: <3F0C3469.2050106@adelis.com> References: <3F0C3469.2050106@adelis.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-cTSw5NqOMpNeAjx5c2EN" Message-Id: <1057843920.46100.123.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 10 Jul 2003 13:32:00 +0000 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/138 X-Sequence-Number: 14252 --=-cTSw5NqOMpNeAjx5c2EN Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable On Wed, 2003-07-09 at 15:27, Beno=EEt Bournon wrote: > I have to make a function that returns a tree with title and link of a=20 > table. >=20 > Recursively, a information depends on a parent information. >=20 > It is to organise a menu with parent dependance. >=20 > How is it possible and faster ? in C ? pl/pgsql or other ? If your only concern is speed, go with a C function. This (however) can make backing up / restoring the database to a different machine a little bit cumbersome. You need to be sure to install the modules on the other box manually prior to restoring the database itself. --=-cTSw5NqOMpNeAjx5c2EN Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/DWrP6DETLow6vwwRAvInAJ94IwyAmj/vDIASJJV38jpt41hUywCeMRWN pf+jE3GmBUesR3zJcOET3Qg= =WSKw -----END PGP SIGNATURE----- --=-cTSw5NqOMpNeAjx5c2EN--