Re: Question with tsearch2 (or it might be a general one

From: Chris <dmagick(at)gmail(dot)com>
To: ritesh-nadhani(at)uiowa(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question with tsearch2 (or it might be a general one
Date: 2006-10-23 05:17:54
Message-ID: 453C5082.4060208@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ritesh Nadhani wrote:
> 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?

It is specific to tsearch2 and it tells postgres how to do the
comparison between the two items - much the same as '=' or '>' do.

If you log in to psql and do:

\do @@

It will list all '@@' operators and show you what data etc it will be
expecting in each case (each operator can be used in a different context
depending on what type of data you're using).

If you really want to look at what it does, look at the tsearch2 source
code, it'd be in there somewhere (grep for 'create operator' and go from
there).

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joost Kraaijeveld 2006-10-23 05:54:37 How to determine initdb parameters on old database?
Previous Message Tom Lane 2006-10-23 04:50:27 Re: How to find out about zlib compression