On 23/02/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Anton Melser" <melser(dot)anton(at)gmail(dot)com> writes:
> > 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?
>
> You need plperl (or pltcl; likely plpython would work too) --- the
> built-in regex functions don't have any way to return more than the
> first match. There's a patch pending to provide more functionality
> here for 8.3, but it won't help you today.
Thanks for the info
Cheers
Anton