Re: [mapserver-users] Re: postgres fulltext search

2010-05-05 Thread Steve Grey
Matt, Just picked up on the thead, sorry for the late posting. In PostgreSQL, for full-text indexing in TSearch2 (don't know if your FTS experience is with PG), you can also build with plainto_tsquery(), and if you want to avoid the dictionary stemming etc., prepare the index and use the search w

[mapserver-users] Re: postgres fulltext search

2010-05-05 Thread mattmendick
Andy- Thanks a ton for taking a look at this for me. In looking around some more talking about variable substitution, I found that I can do a FILTER like you mentioned in the layer section of the mapfile. I could do a: FILTER "city @@ ts_vector('%mycitysearch%')" and then in the mapserver requ

Re: [mapserver-users] Re: postgres fulltext search

2010-05-05 Thread Andy Colson
On 5/5/2010 9:28 AM, mattmendick wrote: Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? Ok, I think I found the spot in the source where it uses 'PropertyIsLike'. (I'm found it in FLTGetIsLikeComparisonSQLExpression) It's in a totally

Re: [mapserver-users] Re: postgres fulltext search

2010-05-05 Thread Andy Colson
On 5/5/2010 9:28 AM, mattmendick wrote: Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? A quick look into the source (mappostgis.c) , I dont see anything similar. However, when it's building the where clause of the sql, it tacks on the

[mapserver-users] Re: postgres fulltext search

2010-05-05 Thread mattmendick
Correct, that is what I'm asking ultimately. What is the "attributal" equivalent to !BBOX! if it exists? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009128.html Sent from the Mapserver - User mailing list archive at Nabble.com.