I made some changes to textsearch.sgml, the FTS
documentation. It contained references to a table 'pgweb'
that was nowhere to be found, and a similarly unreferenced
'apod' table, which I happened to have found earlier here:
http://www.sai.msu.su/~megera/postgres/fts/apod.dump.gz
(it has around 1700 rows).
I changed all references to 'pgweb' to 'apod'. This apod
table initially corresponds with the structure of the
table in the dump file. (In the documentation, that table
is subsequently changed by adding a tsvector column.)
It would be nice if that apod table could be included with
postgres in its entirety, or maybe even an updated
version, as the above dump only contains records from
1995-2001. In case the table is deemed to large for
inclusion in the distribution, I have put the initial
'create' statements and selected 20 records, so that the
example queries give some results (albeit fewer results
than there are in the textsearch.sgml document now - it
was apparently run with a full apod table).
With these changes (from table 'pgweb' to 'apod') the
examples can be run.
If the table data is included (whole or truncated) a
paragraph saying where to find it should be written
too.
Erik Rijkers
textsearch.sgml.diff
Description: Binary data
apod_create_table.sql
Description: Binary data
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
