Opened 12 years ago
Closed 12 years ago
#4176 closed enhancement (fixed)
Ability to do use PropertyIsLike with a column of a different type than text (POSTGIS)
Reported by: | aboudreault | Owned by: | aboudreault |
---|---|---|---|
Priority: | normal | Milestone: | 6.2 release |
Component: | MapServer C Library | Version: | unspecified |
Severity: | normal | Keywords: | |
Cc: | adube, jlacroix |
Description
It would be useful for some case to be able to do a PropertyIsLike on a column of a different type than text. Currently, postgresql is just throwing an error because it doesn't support LIKE/ILIKE for this case.
This issue can easily be fixed by adding a cast to convert the column to text:
select * from popplace where gid::text LIKE '%2%';
I'm going to add the support for postgis. Since I do not want to query the column type to PGSQL, I'm going to always cast the column. I've analyze the query in psql... and there is no performance impact. Postgresql won't cast a column that is already of type text.
Note:
See TracTickets
for help on using tickets.
Fixed and committed in r13099.