Re: pattern search - Mailing list pgsql-general

From Joel Burton
Subject Re: pattern search
Date
Msg-id JGEPJNMCKODMDHGOBKDNKEFKCPAA.joel@joelburton.com
Whole thread Raw
In response to pattern search  (ktt <kestutis98@yahoo.com>)
List pgsql-general
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of ktt
> Sent: Thursday, May 23, 2002 11:06 AM
> To: pgsql-general@postgresql.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@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres under CygWin
Next
From: Darren Ferguson
Date:
Subject: Re: pattern search