Re: locale and spanish acute
От | Martín Marqués |
---|---|
Тема | Re: locale and spanish acute |
Дата | |
Msg-id | 20010917204951.B9D012AB45@bugs.unl.edu.ar обсуждение исходный текст |
Ответ на | Re: locale and spanish acute (Tony Grant <tony@animaproductions.com>) |
Ответы |
Re: locale and spanish acute
|
Список | pgsql-general |
On Lun 17 Sep 2001 04:31, Tony Grant wrote: > On Fri, 2001-09-14 at 15:49, Peter Eisentraut wrote: > > Martín Marqués writes: > > > select count(*) from tab1 where col1 LIKE '%mas%' > > > > > > but I would like it to catch rows with "más" also. > > select count(*) from tab1 where col1 ILIKE to_ascii($1) > > works for me. But I want it to work with más too. For that I would need to change that query for this one: select count(*) from tab1 where to_ascii(col1) ILIKE to_ascii($1) Right? Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | mmarques@unl.edu.ar Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------
В списке pgsql-general по дате отправления: