Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Full-Text search on multiple columns
Fri, Jan 12 2007 5:19 PMPermanent Link

Brent
Is there a way to do a full text search on all columns in the index without specifying
each column individually in the search?

Right now I'm using:

select * from names where textsearch('james' in last_name) or textsearch('james' in
first_name);

It seems more intuitive (at least to me) to use:

select * from names where textsearch('james');

so it searches all columns in the full-text index.

Brent
Fri, Jan 12 2007 6:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Brent,

<< Is there a way to do a full text search on all columns in the index
without specifying each column individually in the search? >>

No.  We did it this way in order to allow for you to specify AND, OR, or NOT
boolean combinations as needed to manipulate the search criteria.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Jan 12 2007 11:12 PMPermanent Link

Brent
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Brent,

<< Is there a way to do a full text search on all columns in the index
without specifying each column individually in the search? >>

No.  We did it this way in order to allow for you to specify AND, OR, or NOT
boolean combinations as needed to manipulate the search criteria.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
    Ok, that makes sense. Thanks. Smile

Brent

Image