Thread: "connect by"

I need a high performing version of Oracle's connect by functionality in
PostgreSQL.  I saw some dispute about attempts to add this in the
archives and a reference to an ANSI alternative "with" statement.  Is
either of these functions available yet?  I'm using 8.3.


Jon

Roberts, Jon <Jon.Roberts@asurion.com> schrieb:

> I need a high performing version of Oracle's connect by functionality in
> PostgreSQL.  I saw some dispute about attempts to add this in the
> archives and a reference to an ANSI alternative "with" statement.  Is
> either of these functions available yet?  I'm using 8.3.

unfortunately no, wait for 8.4 ;-(


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

On Jun 9, 4:54 pm, Jon.Robe...@asurion.com ("Roberts, Jon") wrote:
> I need a high performing version of Oracle's connect by functionality in
> PostgreSQL.  I saw some dispute about attempts to add this in the
> archives and a reference to an ANSI alternative "with" statement.  Is
> either of these functions available yet?  I'm using 8.3.
>
> Jon
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

If you are building a tree, then an ltree contrib package will be a
great help http://www.postgresql.org/docs/8.3/interactive/ltree.html

-- Valentine