Re: Query inside RTF - Mailing list pgsql-general

On jue, 2009-10-08 at 17:51 -0300, Emanuel Calvo Franco wrote:

> part=# select * from p  where i::text ~~ $$%\\\\''f3%$$;
>     i
> ----------
>  \\\\''f3
> (1 row)
>
> I don't have any problem, wich enconding you are using?
> (select getdatabaseencoding(); )
>

Thanks, now this works:

set standard_conforming_strings = 0;

select
  idturno,
  infres::text
from turno
where
  infres::text ~~ $$%diagn\\\\'f3stico%$$;

This database has WIN1252 encoding.

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