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