| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "David Goodenough *EXTERN*" <david(dot)goodenough(at)btconnect(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regular express question |
| Date: | 2007-06-22 14:00:05 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB20381A08A@EXADV1.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Goodenough wrote:
>
> I have a table that consists of a set of regular expressions, a
priority
> and a result. I need to be able to match field in another table
against
> the set of regular expressions (ordered by priority) and use the first
result.
>
> Reading the documentation I can see how to put the regular expression
> into an SQL statement (that is as text or a ? which my code provides)
but
> I can not see how to get the expression from the table.
The only way I can see is to write a function in - say - PL/pgSQL.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2007-06-22 14:10:46 | Re: How to install Postgresql on MS Vista? |
| Previous Message | D.J. Heap | 2007-06-22 13:44:47 | Re: How to install Postgresql on MS Vista? |