Re: Help! Storing trees in Postgres - Mailing list pgsql-sql

From kovacsz
Subject Re: Help! Storing trees in Postgres
Date
Msg-id Pine.LNX.4.10.10011031154010.13638-100000@tir.tir
Whole thread Raw
In response to Help! Storing trees in Postgres  ("Sergei O . Naumov" <naumov@r-style.donpac.ru>)
List pgsql-sql
> Is there any way to implement a query in Postgres that would be in some way
> analogues to Oracle's START WITH/CONNECT BY structure?
Unfortunately, no such statements. Instead, you should write your own
functions which can operate on your own defined table. The table
represents the edges of the tree ("from" and "to"). You might have a look
on
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz/Linux/PostgreSQL/strukturak/

for some details about using partially ordered trees.

Regards, Zoltan






pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: shared memory problem
Next
From: "ANDREAS STEINBACH"
Date:
Subject: Oracle, ODBC, MS IIS -> problem!