pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp! Storing trees in Postgres
2+ messages / 2 participants
[nested] [flat]
* Help! Storing trees in Postgres
@ 2000-11-01 14:02 Sergei O . Naumov <naumov@r-style.donpac.ru>
2000-11-04 20:09 ` Re: Help! Storing trees in Postgres kovacsz <zoli@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 1 reply; 2+ messages in thread
From: Sergei O . Naumov @ 2000-11-01 14:02 UTC (permalink / raw)
To: pgsql-sql
Hi!
I just subscribed myself to this list and sent a message but I am not sure
that
it reached the list. So, I am asking one more time. :-)
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?
I'd very much appreciate any suggestions.
Thanks in advance,
Sergei
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Help! Storing trees in Postgres
2000-11-01 14:02 Help! Storing trees in Postgres Sergei O . Naumov <naumov@r-style.donpac.ru>
@ 2000-11-04 20:09 ` kovacsz <zoli@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 0 replies; 2+ messages in thread
From: kovacsz @ 2000-11-04 20:09 UTC (permalink / raw)
To: Sergei O . Naumov <naumov@r-style.donpac.ru>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-04 20:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-01 14:02 Help! Storing trees in Postgres Sergei O . Naumov <naumov@r-style.donpac.ru>
2000-11-04 20:09 ` kovacsz <zoli@pc10.radnoti-szeged.sulinet.hu>
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