Doug, numnode exists for sure ! It's plainto_tsquery function which Teodor used in example, appeared in 8.2 Oleg On Mon, 15 Jan 2007, Doug Cole wrote:
That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core). Is it new to 8.2? Is there a similar function under 8.1, or at least a decent work-around? Thanks for the help, Doug On 1/15/07, Teodor Sigaev <teodor@xxxxxxxxx> wrote:contrib_regression=# select numnode( plainto_tsquery('the any') ); NOTICE: query contains only stopword(s) or doesn't containlexeme(s), ignorednumnode --------- 0 (1 row) contrib_regression=# select numnode( plainto_tsquery('the table') ); numnode --------- 1 (1 row) contrib_regression=# select numnode( plainto_tsquery('long table') ); numnode --------- 3 (1 row) -- Teodor Sigaev E-mail: teodor@xxxxxxxxx WWW:http://www.sigaev.ru/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
