Re: question regarding regular expressions

Hi Cindy,

--On Montag, 16. September 2002 14:25 -0700 Cindy <ctmoore@uci.edu> wrote:

>
> Tom Lane writes:
>  >Cindy <ctmoore@uci.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