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

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 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.

Brent