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
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2007-02-23 15:19:07|
|Subject: Re: false unique constraint error...for me |
|Previous:||From: Joris Dobbelsteen||Date: 2007-02-23 15:10:07|
|Subject: Re: complex referential integrity constraints|