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

[Steve Lime]

MapServer complains? What is the error message exactly?

>>> Swapnil Hajare <dreamil at GMAIL.COM> 2/27/2007 5:29:38 AM >>>
Steve,
  I wrote such program and added a filter to it and then wrote back
the
mapfile. It doesnt add any extra escape chars or anything like that.
Another
point which I forgot to mention is that the datatype of this
name_hutment_dweller_souindics column is tsvector
  Due to this, the mapserver complains that it cannot cast a tsvector
to
text. Does this mean that mapserver casts query field to text and then
does
query?

bye

On 2/26/07, Steve Lime <Steve.Lime at dnr.state.mn.us> wrote:
>
> There could be some string escaping going on in php or MapServer
itself
> perhaps?
> If you could try one more thing it might help debug.
>
> In PHP write a quick script that does this:
>
> - open the mapfile
> - open the layer
> - use the layer setFilter method to set it to
> "name_hutment_dweller_souindics @@ '(GPN)|(TKRM)'::tsquery"
> - save the mapfile
>
> What does the saved FILTER string look like?
>
> Steve
>
> >>> Swapnil Hajare <dreamil at GMAIL.COM> 2/26/2007 2:24:16 AM >>>
> 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
>



-- 
Swapnil Hajare