On May 30, 2006, at 12:46 , Pedro wrote:
> SELECT * FROM table WHERE name like '%searchstring%' OR description
> like '%searchstring%';
> that doesnt really looks eficient... well... actually it works with
> no problem.
Depending on your needs, that may work just fine. PostgreSQL includes
regex matching as well.
> anyway... what's the standard query for a text search?
If you're looking for full text search, take a look at tsearch2 in
grzm seespotcode net
In response to
pgsql-general by date
|Next:||From: Francisco Reyes||Date: 2006-05-30 03:55:38|
|Subject: Re: Status of gist locking in 8.1.3?|
|Previous:||From: Pedro||Date: 2006-05-30 03:46:57|
|Subject: whats the standard text search query?|