Re: Inside the Regex Engine

Andrew Dunstan <andrew@dunslane.net> wrote:
> Tom Lane wrote:
> 
>>david@fetter.org (David Fetter) writes:
>>  
>>
>>>While PL/Perl is great, it's not available everywhere, and I'd like
>>>to be able to grab atoms from a regex match in, say, a SELECT.  Is
>>>there some way to get access to them?
>>
>>There's a three-parameter variant of substring() that allows
>>extraction of a portion of a regex match --- unfortunately it uses
>>SQL99's brain-dead notion of regex, which will not satisfy any Perl
>>weenie :-(
>>
>>I think it'd be worth our while to define some comparable
>>functionality that depends only on the POSIX regex engine ...
> 
> substitute should be relatively straightforward, I guess; split and
> match maybe less so - what do you return? An array?

That would be great.

> Or you could require an explicit subscript to get a particular
> return value as in split_part(), which would be potentially
> inefficient if you want more than one (although I guess results
> could be cached).

That'd be good, too.

Cheers
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100    cell: +1 415 235 3778

My definition of a free society is a society where it is safe to be
unpopular.                                                   Adlai Stevenson