Re: question regarding regular expressions

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.

            regards, tom lane