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: | Raw Message | Whole Thread | 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? |