Mapscript: can't use @@ operator for querying postgis layer

[Swapnil Hajare]

Steve,
  I added a filer like this in my mapfile
       FILTER "name_hutment_dweller_souindics @@ '(GPN)|(TKRM)'::tsquery"
  and I generated png from mapfile using shp2img. I can see matching
polygins displayed in the image, That means postGIS is processing the query
correctly. Is it the queryByAttributes which is making mistake then?


regards,

On 2/18/07, Steve Lime <Steve.Lime at dnr.state.mn.us> wrote:
>
> MapServer or MapScript passes the query string directly on to the
> PostGIS driver so
> it's likely there the problem lies (if there is one). What happens if
> you set a FILTER
> in the map file using that operator and use shp2img? That might help in
> debugging
> this since queryByAttributes simply resets the layer filter temporarily.
>
> Steve
>
> >>> Swapnil Hajare <dreamil at GMAIL.COM> 02/16/07 10:14 PM >>>
> Hi list,
>   first greetings to the list.
>   I am using mapserver 4.8.3 (ubuntu edgy package) with postgis-pgsql
> 8.1
> and php5-mapscript.
>   I am trying to implement full text search engine for Marathi-
> Devanagari
> text (mr_IN) using tsearch2 extension of pgsql. In my map, I am
> providing a
> search interface (which is based on kamap & mapscript), to type text in
> Marathi and search it in my postgis layer.  For string comparison in
> queryByAttributes, I get results when I use ~* operator. But I don't get
> any
> results when I try to use @@ operator. is it that this operator is not
> supported by mapscript? I thought anything supported by pgsql, should be
> available in mapscript also. Please guide me on this.
>
> regards,
>
>
> --
> Swapnil Hajare
>
>


-- 
Swapnil Hajare
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070226/6e1713d3/attachment.htm>