"Andy Kriger" <akriger@greaterthanone.com> writes:
> I see that it's possible to select using regexps.
> Is it possible to use portions of the selection in the result?
The POSIX version of substring() might do what you want:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-matching.html#FUNCTIONS-POSIX-REGEXP
I forget whether that's available in any version before 7.3.
If not, the next step would be to write a little function in plperl or
pltcl to mash the string however you want ...
regards, tom lane