Skip site navigation (1) Skip section navigation (2)

Re: whats the standard text search query?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Pedro <pedro100(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: whats the standard text search query?
Date: 2006-05-30 03:52:30
Message-ID: 9B1C8746-B8F4-411B-9205-F47DCABFD34C@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-general
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




In response to

pgsql-general by date

Next:From: Francisco ReyesDate: 2006-05-30 03:55:38
Subject: Re: Status of gist locking in 8.1.3?
Previous:From: PedroDate: 2006-05-30 03:46:57
Subject: whats the standard text search query?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group