On 23/02/07, Anton Melser <melser(dot)anton(at)gmail(dot)com> wrote:
> Hi,
> I need to be able to get all the matches for a particular regexp from
> a text field that I need to use in another query in a function. Is
> this possible with plpgsql? Do I have to install the perl language?
> Cheers
> Anton
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
yes. use "like" or "~"
see
http://www.postgresql.org/docs/8.2/static/functions-matching.html
There is no need to use perl.
Peter.