Re: Bug with Tsearch and tsvector

Jasen Betts  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