Re: how to ignore accents?

Поиск
Список
Период
Сортировка
От Ennio-Sr
Тема Re: how to ignore accents?
Дата
Msg-id 20050402141141.GA2107@deby.ei.hnet
обсуждение исходный текст
Ответ на Re: how to ignore accents?  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: how to ignore accents?  (Ennio-Sr <nasr.laili@tin.it>)
Список pgsql-novice
* Michael Fuhr <mike@fuhr.org> [010405, 18:41]:
> On Fri, Apr 01, 2005 at 08:36:35PM +0200, Ennio-Sr wrote:
> >
> >       RETURN translate($1, "\342\347\350\351\352\364\373", "aceeeou");
> >                            ^                           ^  ^       ^

>
> See the PL/pgSQL documentation to get a better idea of the syntax:
>
> http://www.postgresql.org/docs/7.4/interactive/plpgsql.html
>
>     RETURN translate($1, ''ABC'', ''abc'');
>                          ^^   ^^  ^^   ^^

Hi Michael,
thank you for the nice lessson and for the very instructive link.
I read it thouroughly, went back to my example and still got the same
error: Grrr!!!!!!!!!!!
Then, finally, I discovered my error was as stupid as the difference
between _"_ and _''_ !
Now it works greatly! ..... :-)
Cheers,
    Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]

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

Предыдущее
От: Kim Kohen
Дата:
Сообщение: Re: Boolean search
Следующее
От: Ennio-Sr
Дата:
Сообщение: Re: how to ignore accents?