Re: Search strings

Not long ago, Peter Landis proclaimed...
> I'm a newbie at postgresql and created a relational
> database with perl. What my question is, how do you
> do a string search in postgresql? I know you can
> search for string comparisons in oracle but was
> wondering if this is possible in postgresql? So far
> I've been using the SELECT syntax for finding words in
> the database, but this is assuming that the word is
> exactly the same. If anyone could advise me on this
> minor problem, I would greatly appreciate it.

Very possible. There are several string operators in PostgreSQL. One of my
favorite is ~* which does a case-insensitive regular expression search.

SELECT * FROM TABLE1 WHERE FIELD1 ~* 'dog';

Hope that helps.

-=Fozz

--
Doran L. Barton <fozz(at)iodynamics(dot)com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>