Thread: BUG: wrong doc or wrong connectby?

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.

<Eugen.Konkov@aldec.com> writes:
> ERROR:   function connectby(unknown, unknown, unknown, unknown, integer, unknown) does not exists

You didn't install that contrib module.
http://www.postgresql.org/docs/8.3/static/contrib.html

            regards, tom lane

Please, can you put this hint to 'F29. tablefunc' chapter:
NOTICE: You need to install contrib module

thx

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: <Eugen.Konkov@aldec.com>
Cc: <pgsql-bugs@postgresql.org>
Sent: Friday, March 28, 2008 4:48 PM
Subject: Re: [BUGS] BUG: wrong doc or wrong connectby?


> <Eugen.Konkov@aldec.com> writes:
>> ERROR:   function connectby(unknown, unknown, unknown, unknown, integer,
>> unknown) does not exists
>
> You didn't install that contrib module.
> http://www.postgresql.org/docs/8.3/static/contrib.html
>
> regards, tom lane

Eugen.Konkov@aldec.com wrote:
> Please, can you put this hint to 'F29. tablefunc' chapter:
> NOTICE: You need to install contrib module

Well, it is here:
http://www.postgresql.org/docs/8.3/interactive/contrib.html

which is the "parent" page.  Are you suggesting that we need to repeat
that text on each and every module's doc?  That seems a tad duplicative.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support