BUG: wrong doc or wrong connectby?

Поиск
Список
Период
Сортировка
От
Тема BUG: wrong doc or wrong connectby?
Дата
Msg-id 037e01c890e1$cc8d41f0$1200a8c0@kharkov.localhost
обсуждение исходный текст
Ответы Re: BUG: wrong doc or wrong connectby?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
PG 8.3.1

http://www.postgresql.org/docs/8.3/interactive/tablefunc.html
I have used copy/past,=20
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, un=
known) does not exists
Character:  15
HINT:   No function matches the given name and argument types. You might ne=
ed to add explicit type casts.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem identifying constraints which should not be inherited
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG: wrong doc or wrong connectby?