in 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 [EMAIL PROTECTED]
Download the latest version of PostgreSQL and look in the contrib/tsearch or
contrib/tsearch2
directories. For documentation, see:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
http://sourceforge.net/mailarchive/forum.php?forum_id=7671
George Essig
QL 7.2.3 and there was no contrib/tablefunc
directory.
You'll have to upgrade.
George Essig
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
an openacs 5.
George Essig
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
