is there a function which elminates spaces?

#1

In a WHERE clause, I want to to compare strings ignoring the spaces
inside them. Is therd 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 epxression, but I do not see it.

#2

"Pierre Couderc" <pierre (AT) couderc (DOT) ccNOSPAM> schreef in bericht
news:djidc4$2hgk$1 (AT) biggoron (DOT) nerim.net...

Quote:

In a WHERE clause, I want to to compare strings ignoring the spaces
inside them. Is therd 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!
Try translating [only] space(s) to .. nothing:

SELECT ... WHERE translate(table.phone_number,' ','') = translate(?,' ','');

be aware this will never use an index!

HansH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

is there a function which elminates spaces?

comp.databases.postgresql.general comp.databases.postgresql.general

is there a function which elminates spaces? - 10-24-2005 , 05:34 AM

Re: is there a function which elminates spaces? - 10-24-2005 , 01:00 PM