In the postgres document , postgres support regular expression match.
I think this is what you need. but I haven't test it.
so you can reference postgres document. Hope this information is usful
to you.
Peter Landis wrote:
> Hi-
>
> 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.
>
> Peter Landis
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://messenger.yahoo.com
>
> ************
--
wuulong Sheu ( 許武龍 ) - PGP , HTML mail is welcome
蒙恬科技 - PEN POWER TECHNOLOGY LTD.(www.penpower.com.tw)
wuulong@penpower.com.tw (O)035722691-362 (M)0923135231 (icq)11934112