Query inside RTF

From: "Leonardo M(dot)" Ramé <l(dot)rame(at)griensu(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Query inside RTF
Date: 2009-10-08 13:58:05
Message-ID: 1255010285.2703.42.camel@leonardo-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Massa, Harald Armin 2009-10-08 14:56:43 cost of query done - recorded anywhere?
Previous Message shrikant hanagodimath 2009-10-08 12:53:36 Need info on PQfmod()