Re: pattern search

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of ktt
> Sent: Thursday, May 23, 2002 11:06 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] pattern search
>
>
> hello,
>
> is it possible to make a search
> for a pattern in PostgreSQL database,
> using database functions only?
> Or should I use PHP for that
> purpose?

PG supports standard SQL LIKE syntax, as well as full regular expression
syntax. See the section in the document on string functions and pattern
matching for information.

- J

Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant