X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 973F8D1B548; Mon, 27 Oct 2003 14:42:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 54384-08; Mon, 27 Oct 2003 10:42:22 -0400 (AST) Received: from cola.bit.te.ua (unknown [217.196.164.57]) by svr1.postgresql.org (Postfix) with ESMTP id ABFA1D1B55D; Mon, 27 Oct 2003 10:42:11 -0400 (AST) Received: from city.gov.te.ua (IDENT:1000@cit-mars.l5.city.int [10.0.1.33]) by cola.bit.te.ua (8.11.6/8.11.6) with ESMTP id h9REgAW16758; Mon, 27 Oct 2003 16:42:13 +0200 Message-ID: <3F9D2EC2.9060204@city.gov.te.ua> Date: Mon, 27 Oct 2003 16:42:10 +0200 From: Sergei Levchenko User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031014 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: connectby X-Enigmail-Version: 0.81.7.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1293 X-Sequence-Number: 51365 hi I have menu table: id | integer | not null default nextval('public.menu_id_seq'::text) parent_id | integer | description | text | I do select: test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~') t(id integer, parent_id integer, level int, branch text); id | parent_id | level | branch ----+-----------+-------+------------- 2 | | 0 | 2 4 | 2 | 1 | 2~4 7 | 4 | 2 | 2~4~7 10 | 7 | 3 | 2~4~7~10 16 | 10 | 4 | 2~4~7~10~16 9 | 4 | 2 | 2~4~9 How am I able to select description file from menu table, not only id, parent_id, level, branch fields? -- WBR, sector119