Revision 11657
Added by Aaron Marcuse-Kubitza about 11 years ago
| util.sql | ||
|---|---|---|
| 1598 | 1598 |
|
| 1599 | 1599 |
|
| 1600 | 1600 |
-- |
| 1601 |
-- Name: regexp_matches_group(text, text, integer); Type: FUNCTION; Schema: util; Owner: - |
|
| 1602 |
-- |
|
| 1603 |
|
|
| 1604 |
CREATE FUNCTION regexp_matches_group(str text, re text, group_ integer DEFAULT 1) RETURNS SETOF text |
|
| 1605 |
LANGUAGE sql IMMUTABLE |
|
| 1606 |
AS $_$ |
|
| 1607 |
SELECT regexp_matches[$3] FROM regexp_matches($1, $2, 'g') |
|
| 1608 |
$_$; |
|
| 1609 |
|
|
| 1610 |
|
|
| 1611 |
-- |
|
| 1601 | 1612 |
-- Name: rename_cols(regclass, anyelement); Type: FUNCTION; Schema: util; Owner: - |
| 1602 | 1613 |
-- |
| 1603 | 1614 |
|
Also available in: Unified diff
schemas/util.sql: added regexp_matches_group()