Revision 12450
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1516 | 1516 |
|
| 1517 | 1517 |
|
| 1518 | 1518 |
-- |
| 1519 |
-- Name: first_word(text); Type: FUNCTION; Schema: util; Owner: - |
|
| 1520 |
-- |
|
| 1521 |
|
|
| 1522 |
CREATE FUNCTION first_word(str text) RETURNS text |
|
| 1523 |
LANGUAGE sql IMMUTABLE |
|
| 1524 |
AS $_$ |
|
| 1525 |
SELECT match[1] FROM regexp_matches($1, '^(\S*)') match |
|
| 1526 |
$_$; |
|
| 1527 |
|
|
| 1528 |
|
|
| 1529 |
-- |
|
| 1519 | 1530 |
-- Name: fix_array(anyarray); Type: FUNCTION; Schema: util; Owner: - |
| 1520 | 1531 |
-- |
| 1521 | 1532 |
|
Also available in: Unified diff
schemas/util.sql: added first_word()