Search Postgresql Archives

Mix characters with utf-8 characters on the same query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx '
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!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux