Mix characters with utf-8 characters on the same query - Mailing list pgsql-general

From Daniel Vázquez
Subject Mix characters with utf-8 characters on the same query
Date
Msg-id CA+KJVfx=B__xkyYcJThC+aE2RRhZFtVHOoPgiCLdU22XST2QMQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi guys!

There's a way to mix characters with utf-8 characters on the same query. Some thing like this:

Character: "." (dot)
UTF-8: \u002E

(requisite can't use regex)

For this normal query:
  select * from foo where email like 'email@company.com '
Some thing like this:
  select * from foo where email like 'email@company\u002ecom '
But really I need on Full Text Search query:
  select * from foo where (full_text_search_vector) @@ (to_tsquery('spanish', 'email@company\u002ecom:*'))

Please don't think about why we're trying to match a simple dot in this way. 

Thx!

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Problems with non use of indexes
Next
From: Gavin Flower
Date:
Subject: Re: what Linux to run