| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | david(at)fetter(dot)org (David Fetter) |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Inside the Regex Engine |
| Date: | 2003-12-03 04:05:42 |
| Message-ID: | 26761.1070424342@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
david(at)fetter(dot)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 ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-03 04:12:04 | Re: [HACKERS] fork/exec problem: DynaHashCxt |
| Previous Message | Alvaro Herrera | 2003-12-03 03:38:42 | Re: Inside the Regex Engine |