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
contrib.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend