"Richard DeVenezia" <radevenz@ix.netcom.com> writes:
> What would be the pgsql statement to get a regexp match such as $1 into a
> column ?
> ... In reality I am using much more
> convoluted and complicated regular expressions.
In that case I'd recommend you cut to the chase: just go directly to
plperl or pltcl, according to your preference. Either one will offer
far more flexibility for text-mashing than is available from Postgres'
built-in functions. We don't have a regsub function at all, and our
regexp matcher is pretty limited (it does ISO regexps only, not much
if you're used to perl or tcl).
plperl is fairly new and still suffering teething pains, so you might
have trouble getting it to build on your system. pltcl is more stable.
regards, tom lane