Re: connectby usage question

From: Joe Conway <mail(at)joeconway(dot)com>
To: Eric E <whalesuit(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: connectby usage question
Date: 2006-11-15 09:53:41
Message-ID: 455AE3A5.7010803@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Eric E wrote:
>
> However, we would like to return a numbering the items based on the
> order they return, like so;
>
> 1 (first item)
> 1.1 (1 branch, 1st item)
> 1.2 (1 branch, 2nd item)
> 1.2.1 (1.2 branch, 1st item)
> 1.2.2
> 1.2.2.1
> 1.3

> etc.
> Is there an option in connectby to do this directly, or do we need to
> write another function to do this?

There is no support for this in connectby, but I imagine it wouldn't be
too hard to hack connectby to do it for you. Probably much easier to do
that than try to add it with another function.

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2006-11-15 10:19:54 Recovering deleted or updated rows
Previous Message Alban Hertroys 2006-11-15 09:07:18 Re: ROWTYPE initialization question