Re: Bug with Tsearch and tsvector

Jasen Betts <jasen(at)xnet(dot)co(dot)nz> writes:
> \ is popular in URIs on some platfroms, or is URI a different beast

I hope not, because \ is explicitly disallowed by both the older and
newer versions of that RFC.

I did think of proposing that we allow \ and : in FilePath, which is
currently pretty Unix-centric:

regression=# select * from ts_debug('/foo/bar.baz');
alias | description | token | dictionaries | dictionary | lexemes
-------+-------------------+--------------+--------------+------------+----------------
file | File or path name | /foo/bar.baz | {simple} | simple | {/foo/bar.baz}
(1 row)

regression=# select * from ts_debug(E'C:\\foo\\bar.baz');
alias | description | token | dictionaries | dictionary | lexemes
-----------+-----------------+---------+----------------+--------------+-----------
asciiword | Word, all ASCII | C | {english_stem} | english_stem | {c}
blank | Space symbols | :\ | {} | |
asciiword | Word, all ASCII | foo | {english_stem} | english_stem | {foo}
blank | Space symbols | \ | {} | |
host | Host | bar.baz | {simple} | simple | {bar.baz}
(5 rows)

But that's more or less orthogonal to what URLPath should allow.

regards, tom lane