Re: Is there a function which eliminates spaces? - Mailing list pgsql-novice

On Oct 24, 2005, at 22:24 , Pierre Couderc wrote:

> SELECT (...) WHERE (ignore_spaces(table.phone_number) ~*
> igore_spaces(?));
>
> would be fine but ignore_space() does not exist!

Take a look at translate() or replace(). They may do what you want.

http://www.postgresql.org/docs/8.0/interactive/functions-string.html

test=# select translate('foo  foo', ' ', '') = translate('foo foo
', ' ', '');
?column?
----------
t
(1 row)

Hope this helps.

Michael Glaesemann
grzm myrealbox com