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
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 by date
|Next:||From: Michael Glaesemann||Date: 2005-10-24 13:46:50|
|Subject: Re: Is there a function which eliminates spaces?|
|Previous:||From: Rieback Melanie||Date: 2005-10-24 11:31:00|
|Subject: Re: Displaying current query - eliminating <IDLE>|