Revision 8085
Added by Aaron Marcuse-Kubitza almost 12 years ago
| functions.sql | ||
|---|---|---|
| 505 | 505 |
|
| 506 | 506 |
|
| 507 | 507 |
-- |
| 508 |
-- Name: has_prefix(text, text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 509 |
-- |
|
| 510 |
|
|
| 511 |
CREATE FUNCTION has_prefix(prefix text, str text) RETURNS boolean |
|
| 512 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 513 |
AS $_$ |
|
| 514 |
SELECT substring($2 for length($1)) = $1 |
|
| 515 |
$_$; |
|
| 516 |
|
|
| 517 |
|
|
| 518 |
-- |
|
| 508 | 519 |
-- Name: join_strs_transform(text, text, text); Type: FUNCTION; Schema: functions; Owner: - |
| 509 | 520 |
-- |
| 510 | 521 |
|
Also available in: Unified diff
schemas/functions.sql: Added has_prefix()