Tom Lane <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (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 ...
What pieces of the source code would be involved? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778 Transported to a surreal landscape, a young girl kills the first woman she meets and then teams up with three complete strangers to kill again. Marin County newspaper's TV listing for The Wizard of Oz ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
