Mix characters with utf-8 characters on the same query

From: Daniel Vázquez <daniel2d2art(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Mix characters with utf-8 characters on the same query
Date: 2012-03-03 20:22:16
Message-ID: CA+KJVfx=B__xkyYcJThC+aE2RRhZFtVHOoPgiCLdU22XST2QMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)company(dot)com '
Some thing like this:
select * from foo where email like 'email(at)company*\u002e*com '
But really I need on Full Text Search query:
select * from foo where (full_text_search_vector) @@
(to_tsquery('spanish', 'email(at)company*\u002e*com:*'))

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

Thx!

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-03-03 20:49:16 Re: what Linux to run
Previous Message exclusion 2012-03-03 18:44:37 BUG #6510: A simple prompt is displayed using wrong charset