pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Sergei Levchenko <serg@city.gov.te.ua>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: connectby
Date: Mon, 27 Oct 2003 16:42:10 +0200
Message-ID: <3F9D2EC2.9060204@city.gov.te.ua> (raw)

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




view thread (6+ messages)  latest in thread

Message-ID: <3F9D2EC2.9060204@city.gov.te.ua>
Permalink:  ../3F9D2EC2.9060204@city.gov.te.ua/
Also on:    postgresql.org/message-id/3F9D2EC2.9060204@city.gov.te.ua

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: serg@city.gov.te.ua, pgsql-general@postgresql.org
  Subject: Re: connectby
  In-Reply-To: <3F9D2EC2.9060204@city.gov.te.ua>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox