SELECT trim(trailing ' ' from city_name) AS city_name FROM sys_cities;
You might consider reading the manual as there are a multitude of string
manipulation functions built into postgreSQL....
"Pierre Couderc" <pierre(at)couderc(dot)ccNOSPAM> wrote in message
news:djidc4$2hgk$1(at)biggoron(dot)nerim(dot)net(dot)(dot)(dot)
> 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.