Re: question regarding regular expressions - Mailing list pgsql-general

From Tom Lane
Subject Re: question regarding regular expressions
Date
Msg-id 1097.1032206316@sss.pgh.pa.us
Whole thread Raw
In response to question regarding regular expressions  (Cindy <ctmoore@uci.edu>)
Responses Re: question regarding regular expressions  (Cindy <ctmoore@uci.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: find overlapping address ranges
Next
From: phil young
Date:
Subject: problems compiling pgsql