The following bug has been logged online: Bug reference: 4446 Logged by: Ryan Wallace Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP SP2 Description: Full text search cannot start with an apostrophe Details:
A tsquery cannot be created if the first character is an apostrophe: eg. SELECT * FROM text_search_vectors WHERE text_search_vector @@ to_tsquery('''ksan&panel') Error Generated: ERROR: syntax error in tsquery: "'ksan&panel" SQL state: 42601 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs