Hi all,
If we look at page 1994 of the PDF manual of 8.4, the select of the connectby
function is broken.
SELECT * FROM connectby(’connectby_tree’, ’keyid’, ’parent_keyid’,
’pos’, ’row2’, 0, AS t(keyid text, parent_keyid text, level int,
branch text, pos int);
could be formatted like this:
SELECT *
FROM connectby(’connectby_tree’, ’keyid’, ’parent_keyid’, ’pos’,
’row2’, 0, '~' )
AS t(keyid text, parent_keyid text, level int, branch text, pos int);
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar