Is there a function which eliminates spaces?

Поиск
Список
Период
Сортировка
От Pierre Couderc
Тема Is there a function which eliminates spaces?
Дата
Msg-id djinao$pr9$1@news.hub.org
обсуждение исходный текст
Ответы Re: Is there a function which eliminates spaces?  (Michael Glaesemann <grzm@myrealbox.com>)
Список pgsql-novice
In a WHERE clause, I want to to compare strings ignoring the spaces
inside them. Is there a function to do that? I do not find it in the
documentation.

SELECT (...) WHERE (ignore_spaces(table.phone_number) ~* igore_spaces(?));

would be fine but ignore_space() does not exist!

Maybe there is a solution based on regular expression, but I do not see it.

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

Предыдущее
От: Rieback Melanie
Дата:
Сообщение: Re: Displaying current query - eliminating
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Is there a function which eliminates spaces?