From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | BUG: wrong doc or wrong connectby? |
Date: | 2008-03-28 14:41:24 |
Message-ID: | 037e01c890e1$cc8d41f0$1200a8c0@kharkov.localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PG 8.3.1
http://www.postgresql.org/docs/8.3/interactive/tablefunc.html
I have used copy/past,
examples about does not work (
CREATE TABLE connectby_tree(keyid text, parent_keyid text, pos int);
INSERT INTO connectby_tree VALUES('row1',NULL, 0);
INSERT INTO connectby_tree VALUES('row2','row1', 0);
INSERT INTO connectby_tree VALUES('row3','row1', 0);
INSERT INTO connectby_tree VALUES('row4','row2', 1);
INSERT INTO connectby_tree VALUES('row5','row2', 0);
INSERT INTO connectby_tree VALUES('row6','row4', 0);
INSERT INTO connectby_tree VALUES('row7','row3', 0);
INSERT INTO connectby_tree VALUES('row8','row6', 0);
INSERT INTO connectby_tree VALUES('row9','row5', 0);
SELECT * FROM connectby('connectby_tree', 'keyid', 'parent_keyid', 'row2', 0, '~')
AS t(keyid text, parent_keyid text, level int, branch text);
42883
ERROR: function connectby(unknown, unknown, unknown, unknown, integer, unknown) does not exists
Character: 15
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-03-28 14:48:53 | Re: BUG: wrong doc or wrong connectby? |
Previous Message | Dave Page | 2008-03-28 13:26:22 | Re: [BUGS] Documentation commenting does not work |