Any idea what
ERROR: tuplestore_gettuple: invalid state
could mean ?
I took the tablefunc from 7.3.3 and installed it on a 7.3.2 system.
SELECT * FROM connectby('nav', 'id_nav', 'id2_nav', 'pos', '1', 0) as
tree (id_nav int, id2_nav int, level int, serial int) join nav using
(id_nav) order by tree.serial;
TIA
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de