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
Peter Landis wrote:
> 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.
wuulong Sheu ( 許武龍 ) - PGP , HTML mail is welcome
蒙恬科技 - PEN POWER TECHNOLOGY LTD.(www.penpower.com.tw)
wuulong(at)penpower(dot)com(dot)tw (O)035722691-362 (M)0923135231 (icq)11934112
In response to
pgsql-general by date
|Next:||From: Stephen Birch||Date: 1999-12-30 13:37:33|
|Subject: Web mail list search engine broken?|
|Previous:||From: 武龍||Date: 1999-12-30 01:35:32|
|Subject: Re: [GENERAL] Admin / client tools for Win32?|