From: | "Joel Burton" <joel(at)joelburton(dot)com> |
---|---|
To: | "ktt" <kestutis98(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pattern search |
Date: | 2002-05-23 17:35:16 |
Message-ID: | JGEPJNMCKODMDHGOBKDNKEFKCPAA.joel@joelburton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2002-05-23 17:40:43 | Re: pattern search |
Previous Message | Tom Lane | 2002-05-23 16:29:44 | Re: Postgres under CygWin |