Re: question regarding regular expressions

Hi Cindy,

--On Montag, 16. September 2002 14:25 -0700 Cindy <ctmoore(at)uci(dot)edu> wrote:

>
> Tom Lane writes:
> >Cindy <ctmoore(at)uci(dot)edu> writes:
> >> If I've got something like "...AND citation ~ 'x[0-9]*'..." in my
> >> query, is there any way to extract the portion that matched?
> >
> >Not in SQL --- but you could easily write a plperl or pltcl function
> >to do that.
>
> OK, I'm looking over the documentation for this. One question,
> which doesn't seem to be addressed in the documentation
> (http://www.postgresql.org/idocs/index.php?plperl-install.html)
> I'm looking at, it says that you must issue a
> createlang plperl <dbname>
> in order to make use of this in a particular database. Does this
> need to be done prior to populating the database, or can it be done
> any time subsequent?

This can be done any time. And you dont have to stuck with perl,
even python (plpython) is a choice :)

Regards
Tino