Query inside RTF

Поиск
Список
Период
Сортировка
От Leonardo M." Ramé
Тема Query inside RTF
Дата
Msg-id 1255010285.2703.42.camel@leonardo-laptop
обсуждение исходный текст
Ответы Re: Query inside RTF  (Merlin Moncure <mmoncure@gmail.com>)
Re: Query inside RTF  (Sam Mason <sam@samason.me.uk>)
Re: Query inside RTF  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Список pgsql-general
Hi, in my database I store RTF files inside a Bytea field. Now a
customer is requesting a search inside RTF fields and I'm trying to
implement it by issuing this query:

select
  *
from my_table
where
  cast(rtf_field as varchar) like '%condition%'

This works ok when the condition doesn't include accented chars. RTF
escapes accented characters as "\'f1" for í, "\'f3" for ó, and so on.

To escape \ and ', I'd read it shuld be used \\ and '', so I thaugth
that a like '%diagn\\\\''f3stica%' should get "diagnóstica", but it
doesn't.

Any hint on this?

--
Leonardo M. Ramé
Griensu S.A. - Medical IT Córdoba
Tel.: 0351-4247979


В списке pgsql-general по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Using complex PRIMARY KEY
Следующее
От: ssmagin
Дата:
Сообщение: Re: interface for "non-SQL people"