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

help / color / mirror / Atom feed
From: Benoît BOURNON <benoit.bournon@adelis.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] connectby
Date: Tue, 28 Oct 2003 15:29:40 +0100
Message-ID: <3F9E7D54.9040805@adelis.com> (raw)
In-Reply-To: <20031028022356.45528.qmail@web80208.mail.yahoo.com>
References: <20031028022356.45528.qmail@web80208.mail.yahoo.com>

I use postgresql 7.2.3
How can I use connectby ??

Must I install files ? or packages ? or it is recommanded to upgrade 
dataserver ?


George Essig wrote:

>>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
>>    
>>
>
>Try a join with the original table:
>
>SELECT t.*, description FROM connectby('menu','id','parent_id','2',0,'~') 
>AS t(id integer, parent_id integer, level int, branch text), menu 
>WHERE t.id = menu.id
>
>George Essig
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>  
>

view thread (6+ messages)  latest in thread

Message-ID: <3F9E7D54.9040805@adelis.com>
Permalink:  ../3F9E7D54.9040805@adelis.com/
Also on:    postgresql.org/message-id/3F9E7D54.9040805@adelis.com

 · 

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: benoit.bournon@adelis.com, pgsql-general@postgresql.org
  Subject: Re: [SQL] connectby
  In-Reply-To: <3F9E7D54.9040805@adelis.com>

* 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