Skip site navigation (1) Skip section navigation (2)

Is there a function which eliminates spaces?

From: Pierre Couderc <pierre(at)couderc(dot)cc>
To: pgsql-novice(at)postgresql(dot)org
Subject: Is there a function which eliminates spaces?
Date: 2005-10-24 13:24:48
Message-ID: djinao$pr9$1@news.hub.org (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2005-10-24 13:46:50
Subject: Re: Is there a function which eliminates spaces?
Previous:From: Rieback MelanieDate: 2005-10-24 11:31:00
Subject: Re: Displaying current query - eliminating <IDLE>

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group