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.

Change History (1)

comment:1 by aboudreault, 12 years ago

Resolution: fixed
Status: newclosed

Fixed and committed in r13099.

Note: See TracTickets for help on using tickets.