Ritesh -- You are correct in thinking that "@@" is a special operator defined for tesearch2; it uses the GIST indexes to do a search, but more than that I can't say, since I am not really familiar with tsearch2. (In the postGIS world there is a vaguely equivalent operator, "&&", again using postgres' ability to define ones own data types and functions. HTH, Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Ritesh Nadhani Sent: Thu 10/19/2006 11:38 AM To: pgsql-general@xxxxxxxxxxxxxx Cc: Subject: [GENERAL] Question with tsearch2 (or it might be a general one too) Hello A newbie to PostgreSQL from MySQL and just trying to learn tsearch2. In one of the examples at: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html the query given is: SELECT intindex, strTopic FROM tblmessages WHERE idxfti @@ to_tsquery('default', 'gettysburg & address') AND strMessage ~* '.*men are created equal.*'; What does the '@@' in the query means? I did a search at: http://search.postgresql.org/www.search?ul=http%3A%2F%2Fwww.postgresql.org%2Fdocs%2F8.1%2Finteractive%2F%25&fm=on&cs=utf-8&q=%40%40 an it dosnt return any result. Is this specific to tsearch2? What does that mean? Ritesh ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ------------------------------------------------------- Click link below if it is SPAM gsw@xxxxxxxxxxxxxxxx "https://mailscanner.globexplorer.com/dspam/dspam.cgi?signatureID=453969c4232531465134470&user=gsw@xxxxxxxxxxxxxxxx&retrain=spam&template=history&history_page=1"; !DSPAM:453969c4232531465134470! -------------------------------------------------------
